---------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/clotairemit.edu/Dropbox (MIT)/J-PAL Raskin Transition/10_Analysis&Results/Agent Experiment Analysis/03_
> Logs/20240426_baseline_susenas_clean.log
  log type:  text
 opened on:  26 Apr 2024, 00:05:18

. 
. /*----------------------------------------------------*/
.     /* Section: Create Mar 2016 Baseline Variables*/
. /*----------------------------------------------------*/
. 
. // load Mar 2016 household dataset
. u "$importable/susenas16mar_kr.dta", clear

. 
. ** House variables
. 
. tab r1501

      r1501 |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      1,628        0.56        0.56
          1 |    247,090       84.79       85.35
          2 |     35,313       12.12       97.47
          3 |      4,783        1.64       99.11
          4 |      1,427        0.49       99.60
          5 |        685        0.24       99.83
          6 |        281        0.10       99.93
          7 |        207        0.07      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. rename r1501 n_hh_house

. 
. summ r1503

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
       r1503 |    291,414    73.55639    55.97843          3        997

. rename r1503 area

. 
. tab r1502

      r1502 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    245,390       84.21       84.21
          2 |     19,209        6.59       90.80
          3 |     21,364        7.33       98.13
          4 |      4,752        1.63       99.76
          5 |        699        0.24      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen ownhouse = r1502 == 1

. gen lease = r1502 == 2

. gen freelease = r1502 == 3

. gen companyhouse = r1502 == 4

. gen otherhouse = r1502 == 5

. summ ownhouse lease freelease companyhouse otherhouse

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    ownhouse |    291,414    .8420666    .3646792          0          1
       lease |    291,414    .0659165    .2481366          0          1
   freelease |    291,414    .0733115    .2606476          0          1
companyhouse |    291,414    .0163067    .1266525          0          1
  otherhouse |    291,414    .0023986    .0489173          0          1

. 
. tab r1504

      r1504 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      4,139        1.42        1.42
          2 |      4,454        1.53        2.95
          3 |      5,611        1.93        4.87
          4 |    101,720       34.91       39.78
          5 |     20,355        6.98       46.76
          6 |    140,828       48.33       95.09
          7 |        590        0.20       95.29
          8 |      2,975        1.02       96.31
          9 |     10,424        3.58       99.89
         10 |        318        0.11      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen concreteroof = r1504 == 1

. gen tileroof = r1504 == 2

. gen metalroof = r1504 == 3

. gen clayroof = r1504 == 4

. gen asbestosroof = r1504 == 5

. gen ironsheetroof = r1504 == 6

. gen bambooroof = r1504 == 7

. gen shinglewoodroof = r1504 == 8

. gen fiberpalmroof = r1504 == 9

. gen otherroof = r1505 == 10

. summ *roof

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
concreteroof |    291,414    .0142032    .1183278          0          1
    tileroof |    291,414    .0152841    .1226807          0          1
   metalroof |    291,414    .0192544    .1374181          0          1
    clayroof |    291,414    .3490567    .4766727          0          1
asbestosroof |    291,414    .0698491    .2548929          0          1
-------------+---------------------------------------------------------
ironsheetr~f |    291,414    .4832575    .4997205          0          1
  bambooroof |    291,414    .0020246    .0449502          0          1
shinglewoo~f |    291,414    .0102088    .1005219          0          1
fiberpalmr~f |    291,414    .0357704    .1857176          0          1
   otherroof |    291,414           0           0          0          0

. 
. tab r1505

      r1505 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    184,453       63.30       63.30
          2 |      3,805        1.31       64.60
          3 |     81,757       28.06       92.66
          4 |      9,627        3.30       95.96
          5 |      1,785        0.61       96.57
          6 |      4,012        1.38       97.95
          7 |      5,975        2.05      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen concretewall = r1505 == 1

. gen wovenbamboowall = r1505 == 2

. gen woodwall = r1505 == 3

. gen wovenwoodwall = r1505 == 4

. gen logwoodwall = r1505 == 5

. gen bamboowall = r1505 == 6

. gen otherwall = r1505 == 7

. summ *wall

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
concretewall |    291,414    .6329586    .4819988          0          1
wovenbambo~l |    291,414     .013057    .1135191          0          1
    woodwall |    291,414    .2805528    .4492701          0          1
wovenwoodw~l |    291,414    .0330355    .1787295          0          1
 logwoodwall |    291,414    .0061253    .0780244          0          1
-------------+---------------------------------------------------------
  bamboowall |    291,414    .0137674    .1165241          0          1
   otherwall |    291,414    .0205035     .141715          0          1

. 
. tab r1506

      r1506 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      2,571        0.88        0.88
          2 |    104,022       35.70       36.58
          3 |        292        0.10       36.68
          4 |     15,483        5.31       41.99
          5 |     15,343        5.27       47.26
          6 |    100,736       34.57       81.82
          7 |      2,225        0.76       82.59
          8 |     33,307       11.43       94.02
          9 |     16,814        5.77       99.79
         10 |        621        0.21      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen marblegranitefloor = r1506 == 1

. gen ceramicfloor = r1506 == 2

. gen parquettevinylfloor = r1506 == 3

. gen tilefloor = r1506 == 4

. gen highqualitywoodfloor = r1506 == 5

. gen cementbrickfloor = r1506 == 6

. gen bamboofloor = r1506 == 7

. gen lowqualitywoodfloor = r1506 == 8

. gen soilfloor = r1506 == 9

. gen otherfloor = r1506 == 10

. summ *floor

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
marblegran~r |    291,414    .0088225    .0935131          0          1
ceramicfloor |    291,414    .3569561    .4791025          0          1
parquettev~r |    291,414     .001002    .0316387          0          1
   tilefloor |    291,414    .0531306    .2242942          0          1
highqualit~r |    291,414    .0526502    .2233345          0          1
-------------+---------------------------------------------------------
cementbric~r |    291,414      .34568    .4755903          0          1
 bamboofloor |    291,414    .0076352    .0870455          0          1
lowquality~r |    291,414    .1142944    .3181691          0          1
   soilfloor |    291,414     .057698    .2331719          0          1
  otherfloor |    291,414     .002131    .0461135          0          1

. 
. ** Toilet variables
. tab r1507a

     r1507a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    216,844       74.41       74.41
          2 |     26,924        9.24       83.65
          3 |      9,964        3.42       87.07
          4 |        815        0.28       87.35
          5 |     36,867       12.65      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. 
. gen personaltoilet = r1507a == 1

. gen mutualtoilet = r1507a == 2

. gen communaltoilet = r1507a == 3

. gen notusetoilet = r1507a == 4

. gen noaccesstotoilet = r1507a == 5

. summ *toilet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
personalto~t |    291,414    .7441098    .4363612          0          1
mutualtoilet |    291,414    .0923909    .2895775          0          1
communalto~t |    291,414    .0341919    .1817221          0          1
notusetoilet |    291,414    .0027967      .05281          0          1
noaccessto~t |    291,414    .1265107    .3324247          0          1

. 
. tab r1507b

     r1507b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    224,645       88.54       88.54
          2 |      3,899        1.54       90.07
          3 |      4,917        1.94       92.01
          4 |     20,271        7.99      100.00
------------+-----------------------------------
      Total |    253,732      100.00

. gen goosetoilet = r1507b == 1

. gen closedpitttoilet = r1507b == 2

. gen unclosedpitttoilet = r1507b == 3

. gen squattoilet = r1507b == 4

. gen notoilet = missing(r1507b)

. 
. tab r1507a r1507b

           |                   r1507b
    r1507a |         1          2          3          4 |     Total
-----------+--------------------------------------------+----------
         1 |   195,795      3,249      3,857     13,943 |   216,844 
         2 |    22,320        458        643      3,503 |    26,924 
         3 |     6,530        192        417      2,825 |     9,964 
-----------+--------------------------------------------+----------
     Total |   224,645      3,899      4,917     20,271 |   253,732 

. gen personalgoosetoilet = personaltoilet * goosetoilet

. gen personalclosedpitttoilet = personaltoilet * closedpitttoilet

. gen personalunclosedpitttoilet = personaltoilet * unclosedpitttoilet

. gen personalsquattoilet = personaltoilet * squattoilet

. summ personal?*toilet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
personalgo~t |    291,414    .6718792    .4695299          0          1
personalcl~t |    291,414    .0111491    .1049992          0          1
personalun~t |    291,414    .0132355    .1142818          0          1
personalsq~t |    291,414     .047846    .2134407          0          1

. 
. gen mutualgoosetoilet = mutualtoilet * goosetoilet

. gen mutualclosedpitttoilet = mutualtoilet * closedpitttoilet

. gen mutualunclosedpitttoilet = mutualtoilet * unclosedpitttoilet

. gen mutualsquattoilet = mutualtoilet * squattoilet

. summ mutual?*toilet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
mutualgoos~t |    291,414    .0765921    .2659435          0          1
mutualclos~t |    291,414    .0015716    .0396129          0          1
mutualuncl~t |    291,414    .0022065    .0469214          0          1
mutualsqua~t |    291,414    .0120207    .1089782          0          1

. 
. gen communalgoosetoilet = communaltoilet * goosetoilet

. gen communalclosedpitttoilet = communaltoilet * closedpitttoilet

. gen communalunclosedpitttoilet = communaltoilet * unclosedpitttoilet

. gen communalsquattoilet = communaltoilet * squattoilet

. summ communal?*toilet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
communalgo~t |    291,414     .022408    .1480066          0          1
communalcl~t |    291,414    .0006589    .0256598          0          1
communalun~t |    291,414     .001431    .0378009          0          1
communalsq~t |    291,414    .0096941    .0979805          0          1

. 
. ** Asset vars
. 
. tab r1701a

     r1701a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     31,460       10.80       10.80
          5 |    259,954       89.20      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen lpg5kgmore = r1701a == 1

. summ lpg5kgmore

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  lpg5kgmore |    291,414    .1079564    .3103258          0          1

. 
. tab r1701b

     r1701b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    143,240       49.15       49.15
          5 |    148,174       50.85      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen refrigerator = r1701b == 1

. summ refrigerator

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
refrigerator |    291,414    .4915344    .4999292          0          1

. 
. tab r1701c

     r1701c |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     18,515        6.35        6.35
          5 |    272,899       93.65      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen airconditioner = r1701c == 1

. summ airconditioner

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
airconditi~r |    291,414     .063535    .2439232          0          1

. 
. tab r1701d

     r1701d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      5,928        2.03        2.03
          5 |    285,486       97.97      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen waterheater = r1701d == 1

. summ waterheater

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 waterheater |    291,414    .0203422    .1411682          0          1

. 
. tab r1701e

     r1701e |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      8,302        2.85        2.85
          5 |    283,112       97.15      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen landline = r1701e == 1

. summ landline

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    landline |    291,414    .0284887    .1663646          0          1

. 
. tab r1701f

     r1701f |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     54,115       18.57       18.57
          5 |    237,299       81.43      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen computer = r1701f == 1

. summ computer

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    computer |    291,414     .185698    .3888634          0          1

. 
. tab r1701g

     r1701g |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     53,988       18.53       18.53
          5 |    237,426       81.47      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen goldjewelerymin10gram = r1701g == 1

. summ goldjewelerymin10gram

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
goldjewele~m |    291,414    .1852622    .3885108          0          1

. 
. tab r1701h

     r1701h |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    201,794       69.25       69.25
          5 |     89,620       30.75      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen motorcycle = r1701h == 1

. summ motorcycle

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  motorcycle |    291,414     .692465    .4614737          0          1

. 
. tab r1701i

     r1701i |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      7,373        2.53        2.53
          5 |    284,041       97.47      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen boat = r1701i == 1

. summ boat

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
        boat |    291,414    .0253008    .1570374          0          1

. 
. tab r1701j

     r1701j |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      5,239        1.80        1.80
          5 |    286,175       98.20      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen motorboat = r1701j == 1

. summ motorboat

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   motorboat |    291,414    .0179779    .1328711          0          1

. 
. tab r1701k

     r1701k |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     28,350        9.73        9.73
          5 |    263,064       90.27      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen car = r1701k == 1

. summ car

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
         car |    291,414    .0972843     .296345          0          1

. 
. ** water variables
. tab r1507c

     r1507c |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    105,605       36.24       36.24
          2 |     86,362       29.64       65.87
          3 |      3,449        1.18       67.06
          4 |     37,825       12.98       80.04
          5 |     41,638       14.29       94.33
          6 |     13,549        4.65       98.98
          7 |      2,986        1.02      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen septicdisposal = r1507c == 1 | r1507c == 2

. gen pooldisposal = r1507c == 3

. gen riverdisposal = r1507c == 4

. gen pitholedisposal = r1507c == 5

. gen opendisposal = r1507c == 6

. gen otherdisposal = r1507c == 7

. summ *disposal

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
septicdisp~l |    291,414    .6587432    .4741322          0          1
pooldisposal |    291,414    .0118354    .1081451          0          1
riverdispo~l |    291,414    .1297982    .3360818          0          1
pitholedis~l |    291,414    .1428826    .3499537          0          1
opendisposal |    291,414     .046494    .2105527          0          1
-------------+---------------------------------------------------------
otherdispo~l |    291,414    .0102466    .1007057          0          1

. 
. tab r1508a

     r1508a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     16,543        5.68        5.68
          2 |     62,588       21.48       27.15
          3 |     29,887       10.26       37.41
          4 |      4,130        1.42       38.83
          5 |     36,134       12.40       51.23
          6 |     59,354       20.37       71.59
          7 |     22,046        7.57       79.16
          8 |     28,294        9.71       88.87
          9 |     12,435        4.27       93.14
         10 |      8,160        2.80       95.94
         11 |     11,650        4.00       99.93
         12 |        193        0.07      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen bottleddrinkwater = r1508a == 1

. gen refilldrinkwater = r1508a == 2

. gen meteredtapdrinkwater = r1508a == 3

. gen retailtapdrinkwater = r1508a == 4

. gen pumpdrinkwater = r1508a == 5

. gen protwelldrinkwater = r1508a == 6

. gen unprotwelldrinkwater = r1508a == 7

. gen protspringdrinkwater = r1508a == 8

. gen unprotspringdrinkwater = r1508a == 9

. gen riverdrinkwater = r1508a == 10

. gen raindrinkwater = r1508a == 11

. gen otherdrinkwater = r1508a == 12

. summ bottleddrinkwater refilldrinkwater meteredtapdrinkwater retailtapdrinkwater pumpdrinkwater protwelldrinkwater unprot
> welldrinkwater protspringdrinkwater unprotspringdrinkwater riverdrinkwater raindrinkwater otherdrinkwater

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
bottleddri~r |    291,414     .056768    .2313992          0          1
refilldrin~r |    291,414    .2147735    .4106658          0          1
meteredtap~r |    291,414    .1025586     .303382          0          1
retailtapd~r |    291,414    .0141723     .118201          0          1
pumpdrinkw~r |    291,414    .1239954    .3295769          0          1
-------------+---------------------------------------------------------
protwelldr~r |    291,414    .2036759    .4027314          0          1
unprotwell~r |    291,414    .0756518    .2644407          0          1
protspring~r |    291,414    .0970921    .2960837          0          1
unprotspri~r |    291,414    .0426713    .2021152          0          1
riverdrink~r |    291,414    .0280014     .164977          0          1
-------------+---------------------------------------------------------
raindrinkw~r |    291,414    .0399775    .1959067          0          1
otherdrink~r |    291,414    .0006623    .0257265          0          1

. 
. tab r1509

      r1509 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    128,687       61.82       61.82
          2 |     36,946       17.75       79.57
          3 |     28,488       13.69       93.26
          4 |         27        0.01       93.27
          5 |     14,005        6.73      100.00
------------+-----------------------------------
      Total |    208,153      100.00

. gen personalwater = r1509 == 1

. gen mutualwater = r1509 == 2

. gen communalwater = r1509 == 3

. gen notusewater = r1509 == 4

. gen noaccesswater = r1509 == 5

. 
. tab r1510

      r1510 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     74,775       25.66       25.66
          2 |     50,695       17.40       43.06
          3 |    165,944       56.94      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen buyingdrinkwater = r1510 == 1

. gen subscribedrinkwater = r1510 == 2

. gen notbuyingdrinkwater = r1510 == 3

. 
. tab r1511a

     r1511a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      1,815        0.62        0.62
          2 |     14,409        4.94        5.57
          3 |     47,141       16.18       21.74
          4 |      5,748        1.97       23.72
          5 |     53,944       18.51       42.23
          6 |     71,683       24.60       66.83
          7 |     26,543        9.11       75.93
          8 |     29,878       10.25       86.19
          9 |     14,063        4.83       91.01
         10 |      9,660        3.31       94.33
         11 |     14,091        4.84       99.16
         12 |        506        0.17       99.34
         96 |      1,933        0.66      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen bottledcookwater = r1511a == 1

. gen refillcookwater = r1511a == 2

. gen meteredtapcookwater = r1511a == 3

. gen retailtapcookwater = r1511a == 4

. gen pumpcookwater = r1511a == 5

. gen protectedwellcookwater = r1511a == 6

. gen unprotectedwellcookwater = r1511a == 7

. gen protectedspringcookwater = r1511a == 8

. gen unprotspringcookwater = r1511a == 9

. gen rivercookwater = r1511a == 10

. gen raincookwater = r1511a == 11

. gen othercookwater = r1511a == 12

. gen cookwatersource13 = r1511a == 96

. 
. tab r1512a

     r1512a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        199        0.07        0.07
          2 |        335        0.11        0.18
          3 |     48,375       16.60       16.78
          4 |      2,978        1.02       17.81
          5 |     63,509       21.79       39.60
          6 |     76,301       26.18       65.78
          7 |     30,724       10.54       76.32
          8 |     27,567        9.46       85.78
          9 |     12,462        4.28       90.06
         10 |     23,727        8.14       98.20
         11 |      4,790        1.64       99.85
         12 |        447        0.15      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen bottledwashwater = r1512a == 1

. gen refillwashwater = r1512a == 2

. gen meteredtapwashwater = r1512a == 3

. gen retailtapwashwater = r1512a == 4

. gen pumpwashwater = r1512a == 5

. gen protectedwellwashwater = r1512a == 6

. gen unprotectedwellwashwater = r1512a == 7

. gen protectedspringwashwater = r1512a == 8

. gen unprotspringwashwater = r1512a == 9

. gen riverwashwater = r1512a == 10

. gen rainwashwater = r1512a == 11

. gen otherwashwater = r1512a == 12

. summ *washwater

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
bottledwas~r |    291,414    .0006829     .026123          0          1
refillwash~r |    291,414    .0011496    .0338858          0          1
meter~hwater |    291,414    .1660009    .3720821          0          1
retailtapw~r |    291,414    .0102191    .1005721          0          1
pumpwashwa~r |    291,414    .2179339     .412843          0          1
-------------+---------------------------------------------------------
p~lwashwater |    291,414    .2618302    .4396315          0          1
u~lwashwater |    291,414    .1054308    .3071082          0          1
p~gwashwater |    291,414    .0945974    .2926585          0          1
u~gwashwater |    291,414    .0427639    .2023247          0          1
riverwashw~r |    291,414    .0814202    .2734799          0          1
-------------+---------------------------------------------------------
rainwashwa~r |    291,414    .0164371    .1271494          0          1
otherwashw~r |    291,414    .0015339    .0391351          0          1

. 
. tab r1513

      r1513 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    126,782       43.51       43.51
          2 |      7,600        2.61       46.11
          5 |    153,151       52.55       98.67
          8 |      3,881        1.33      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen publicpipewater = r1513 == 1

. gen publichydrantwater = r1513 == 2

. summ public?*water

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
publicpipe~r |    291,414     .435058    .4957655          0          1
publichydr~r |    291,414    .0260797    .1593727          0          1

. 
. tab r1508b

     r1508b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     37,888       23.94       23.94
          2 |    104,236       65.86       89.80
          8 |     16,139       10.20      100.00
------------+-----------------------------------
      Total |    158,263      100.00

. tab r1508a

     r1508a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     16,543        5.68        5.68
          2 |     62,588       21.48       27.15
          3 |     29,887       10.26       37.41
          4 |      4,130        1.42       38.83
          5 |     36,134       12.40       51.23
          6 |     59,354       20.37       71.59
          7 |     22,046        7.57       79.16
          8 |     28,294        9.71       88.87
          9 |     12,435        4.27       93.14
         10 |      8,160        2.80       95.94
         11 |     11,650        4.00       99.93
         12 |        193        0.07      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen cleandrinkwater = r1508b
(133,151 missing values generated)

. replace cleandrinkwater = 0 if r1508b != .
(158,263 real changes made)

. replace cleandrinkwater = 1 if inlist(r1508a, 1, 2, 3, 4, 10, 11, 12)
(133,151 real changes made)

. summ cleandrinkwater

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
cleandrink~r |    291,414    .4569135     .498141          0          1

. 
. tab r1511b

     r1511b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     49,991       25.49       25.49
          2 |    127,288       64.91       90.40
          8 |     18,832        9.60      100.00
------------+-----------------------------------
      Total |    196,111      100.00

. tab r1511a

     r1511a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      1,815        0.62        0.62
          2 |     14,409        4.94        5.57
          3 |     47,141       16.18       21.74
          4 |      5,748        1.97       23.72
          5 |     53,944       18.51       42.23
          6 |     71,683       24.60       66.83
          7 |     26,543        9.11       75.93
          8 |     29,878       10.25       86.19
          9 |     14,063        4.83       91.01
         10 |      9,660        3.31       94.33
         11 |     14,091        4.84       99.16
         12 |        506        0.17       99.34
         96 |      1,933        0.66      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen cleancookwater = r1511b
(95,303 missing values generated)

. replace cleancookwater = 0 if r1511b != .
(196,111 real changes made)

. replace cleancookwater = 1 if inlist(r1511a, 1, 2, 3, 4, 10, 11, 12)
(93,370 real changes made)

. summ cleancookwater

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
cleancookw~r |    289,481    .3225428    .4674502          0          1

. 
. tab r1512b

     r1512b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     57,825       27.46       27.46
          2 |    133,885       63.58       91.05
          8 |     18,853        8.95      100.00
------------+-----------------------------------
      Total |    210,563      100.00

. tab r1512a

     r1512a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        199        0.07        0.07
          2 |        335        0.11        0.18
          3 |     48,375       16.60       16.78
          4 |      2,978        1.02       17.81
          5 |     63,509       21.79       39.60
          6 |     76,301       26.18       65.78
          7 |     30,724       10.54       76.32
          8 |     27,567        9.46       85.78
          9 |     12,462        4.28       90.06
         10 |     23,727        8.14       98.20
         11 |      4,790        1.64       99.85
         12 |        447        0.15      100.00
------------+-----------------------------------
      Total |    291,414      100.00

. gen cleanwashwater = r1512b
(80,851 missing values generated)

. replace cleanwashwater = 0 if r1512b != .
(210,563 real changes made)

. replace cleanwashwater = 1 if inlist(r1512a, 1, 2, 3, 4, 10, 11, 12)
(80,851 real changes made)

. summ cleanwashwater

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
cleanwashw~r |    291,414    .2774438    .4477381          0          1

. 
. rename exp_cap month_pcexp

. 
. ** Demographic variables
. // merge in individual data
. merge 1:m urut using "$importable/susenas16mar_ki.dta"

    Result                      Number of obs
    -----------------------------------------
    Not matched                             0
    Matched                         1,109,749  (_merge==3)
    -----------------------------------------

. assert _m == 3

. drop _m

. 
. tab r405

       r405 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    556,919       50.18       50.18
          2 |    552,830       49.82      100.00
------------+-----------------------------------
      Total |  1,109,749      100.00

. gen male = r405 == 1

. bysort urut: egen totalmale = total(male)

. drop male

. 
. gen female = r405 == 2

. bysort urut: egen totalfemale = total(female)

. drop female

. 
. tab r403

       r403 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    291,414       26.26       26.26
          2 |    228,561       20.60       46.86
          3 |    460,662       41.51       88.37
          4 |      3,064        0.28       88.64
          5 |     23,786        2.14       90.79
          6 |     52,407        4.72       95.51
          7 |     19,919        1.79       97.30
          8 |      1,017        0.09       97.39
          9 |     28,919        2.61      100.00
------------+-----------------------------------
      Total |  1,109,749      100.00

. gen child = r403 == 3

. bysort urut: egen totalchild = total(child)

. drop child

. 
. ** Telecommunication
. tab r1004a

     r1004a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    560,670       55.01       55.01
          5 |    458,486       44.99      100.00
------------+-----------------------------------
      Total |  1,019,156      100.00

. gen owncell_ind = r1004a == 1

. bysort urut: egen n_cell_hh = total(owncell_ind)

. gen own_cell = n_cell_hh > 0

. drop owncell_ind

. summ n_cell_hh own_cell

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   n_cell_hh |  1,109,749    2.226296    1.445771          0         16
    own_cell |  1,109,749    .9017715    .2976235          0          1

. 
. tab r1005

      r1005 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    161,669       15.86       15.86
          5 |    828,389       81.28       97.14
          8 |     29,098        2.86      100.00
------------+-----------------------------------
      Total |  1,019,156      100.00

. gen usecomputer_ind = r1005 == 1

. bysort urut: egen n_computer_hh = total(usecomputer_ind)

. gen usecomputer = n_computer_hh > 0

. drop usecomputer_ind

. summ n_computer_hh usecomputer

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
n_computer~h |  1,109,749    .6626282     1.14375          0         12
 usecomputer |  1,109,749      .34301     .474715          0          1

. 
. tab r1006

      r1006 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    223,188       21.90       21.90
          5 |    756,614       74.24       96.14
          8 |     39,354        3.86      100.00
------------+-----------------------------------
      Total |  1,019,156      100.00

. gen useinternet_ind = r1006 == 1

. bysort urut: egen n_internet_hh = total(useinternet_ind)

. gen useinternet = n_internet_hh > 0

. summ useinternet n_internet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 useinternet |  1,109,749     .466136    .4988521          0          1
n_internet~h |  1,109,749    .9118269    1.246339          0         13

. 
. tab r1008a

     r1008a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    200,517       89.84       89.84
          5 |     22,225        9.96       99.80
          8 |        446        0.20      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen homeinternet_ind = r1008a == 1

. bysort urut: egen n_homeinternet_hh = total(homeinternet_ind)

. gen homeinternet = n_homeinternet_hh > 0

. drop homeinternet_ind

. summ homeinternet n_homeinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
homeinternet |  1,109,749    .4174367    .4931364          0          1
n_homeinte~h |  1,109,749    .8159512     1.20784          0         13

. 
. tab r1008b

     r1008b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     79,839       35.77       35.77
          5 |    139,627       62.56       98.33
          8 |      3,722        1.67      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen notownhomeinternet_ind = r1008b == 1

. bysort urut: egen n_notownhomeinternet_hh = total(notownhomeinternet_ind)

. gen notownhomeinternet = n_notownhomeinternet_hh > 0

. drop notownhomeinternet_ind

. summ notownhomeinternet n_notownhomeinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
notownhome~t |  1,109,749    .1939312    .3953758          0          1
n_notownho~h |  1,109,749     .326481    .7891682          0         12

. 
. tab r1008c

     r1008c |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     69,096       30.96       30.96
          5 |    151,687       67.96       98.92
          8 |      2,405        1.08      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen officeinternet_ind = r1008c == 1

. bysort urut: egen n_officeinternet_hh = total(officeinternet_ind)

. gen officeinternet = n_officeinternet_hh > 0

. drop officeinternet_ind

. summ officeinternet n_officeinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
officeinte~t |  1,109,749    .1886048    .3911945          0          1
n_officein~h |  1,109,749    .2722922    .6428147          0          8

. 
. tab r1008d

     r1008d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     56,132       25.15       25.15
          5 |    164,500       73.70       98.85
          8 |      2,556        1.15      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen schoolinternet_ind = r1008d == 1

. bysort urut: egen n_schoolinternet_hh = total(schoolinternet_ind)

. gen schoolinternet = n_schoolinternet_hh > 0

. drop schoolinternet_ind

. summ schoolinternet n_schoolinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
schoolinte~t |  1,109,749    .1754334    .3803375          0          1
n_schoolin~h |  1,109,749    .2311144    .5659113          0          9

. 
. tab r1008e

     r1008e |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    100,220       44.90       44.90
          5 |    119,195       53.41       98.31
          8 |      3,773        1.69      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen publicinternet_ind = r1008e == 1

. bysort urut: egen n_publicinternet_hh = total(publicinternet_ind)

. gen publicinternet = n_publicinternet_hh > 0

. drop publicinternet_ind

. summ n_publicinternet_hh publicinternet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
n_publicin~h |  1,109,749    .4101062    .8601707          0         12
publicinte~t |  1,109,749    .2443805    .4297195          0          1

. 
. tab r1008f

     r1008f |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     21,226        9.51        9.51
          5 |    197,150       88.33       97.84
          8 |      4,812        2.16      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen vehicleinternet_ind = r1008f == 1

. bysort urut: egen n_vehicleinternet_hh = total(vehicleinternet_ind)

. gen vehicleinternet = n_vehicleinternet_hh > 0

. drop vehicleinternet_ind

. summ vehicleinternet n_vehicleinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
vehicleint~t |  1,109,749    .0504402    .2188517          0          1
n_vehiclei~h |  1,109,749    .0849922    .4317558          0         12

. 
. tab r1009a

     r1009a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    171,901       77.02       77.02
          5 |     49,416       22.14       99.16
          8 |      1,871        0.84      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_gettinginformation_ind = r1009a == 1

. bysort urut: egen n_int_gettinginformation = total(int_gettinginformation_ind)

. gen int_gettinginformation = n_int_gettinginformation > 0

. summ int_gettinginformation n_int_gettinginformation

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_gettin~n |  1,109,749    .3745523    .4840073          0          1
n_int_gett~n |  1,109,749    .6949977     1.10624          0         13

. drop int_gettinginformation_ind n_int_gettinginformation

. 
. tab r1009b

     r1009b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     75,685       33.91       33.91
          5 |    145,586       65.23       99.14
          8 |      1,917        0.86      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_dohomework_ind = r1009b == 1

. bysort urut: egen n_int_dohomework = total(int_dohomework_ind)

. gen int_dohomework = n_int_dohomework > 0

. summ int_dohomework n_int_dohomework

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_dohome~k |  1,109,749     .232294    .4222957          0          1
n_int_doho~k |  1,109,749    .3158156    .6575817          0          9

. drop n_int_dohomework int_dohomework_ind

. 
. tab r1009c

     r1009c |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     59,489       26.65       26.65
          5 |    159,497       71.46       98.12
          8 |      4,202        1.88      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_email_ind = r1009c == 1

. bysort urut: egen n_int_email = total(int_email_ind)

. gen int_email = n_int_email > 0

. summ int_email n_int_email

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   int_email |  1,109,749    .1480308    .3551306          0          1
 n_int_email |  1,109,749    .2339592    .6520245          0          8

. drop n_int_email int_email_ind

. 
. tab r1009d

     r1009d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    188,307       84.37       84.37
          5 |     33,736       15.12       99.49
          8 |      1,145        0.51      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_socialmedia_ind = r1009d == 1

. bysort urut: egen n_int_socialmedia = total(int_socialmedia_ind)

. gen int_socialmedia = n_int_socialmedia > 0

. summ int_socialmedia n_int_socialmedia

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_social~a |  1,109,749    .4095584    .4917525          0          1
n_int_soci~a |  1,109,749     .767223     1.14486          0         13

. drop n_int_socialmedia int_socialmedia_ind

. 
. tab r1009e

     r1009e |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     26,957       12.08       12.08
          5 |    192,270       86.15       98.23
          8 |      3,961        1.77      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_buysellservice_ind = r1009e == 1

. bysort urut: egen n_int_buysellservice = total(int_buysellservice_ind)

. gen int_buysellservice = n_int_buysellservice > 0

. summ int_buysellservice n_int_buysellservice

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_buysel~e |  1,109,749    .0733724     .260747          0          1
n_int_buys~e |  1,109,749    .1056347    .4268179          0          8

. drop n_int_buysellservice int_buysellservice_ind

. 
. tab r1009f

     r1009f |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    107,694       48.25       48.25
          5 |    112,156       50.25       98.50
          8 |      3,338        1.50      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_recreational_ind = r1009f == 1

. bysort urut: egen n_int_recreational = total(int_recreational_ind)

. gen int_recreational = n_int_recreational > 0

. summ int_recreational n_int_recreational

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_recrea~l |  1,109,749    .2527418    .4345844          0          1
n_int_recr~l |  1,109,749    .4395192     .905498          0         12

. drop n_int_recreational int_recreational_ind

. 
. tab r1009g

     r1009g |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     18,228        8.17        8.17
          5 |    200,849       89.99       98.16
          8 |      4,111        1.84      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_financial_ind = r1009g == 1

. bysort urut: egen n_int_financial = total(int_financial_ind)

. gen int_financial = n_int_financial > 0

. summ int_financial n_int_financial

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_financ~l |  1,109,749    .0474179    .2125312          0          1
n_int_fina~l |  1,109,749    .0704889    .3554072          0          8

. drop n_int_financial int_financial_ind

. 
. tab r1009h

     r1009h |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      8,362        3.75        3.75
          5 |    209,291       93.77       97.52
          8 |      5,535        2.48      100.00
------------+-----------------------------------
      Total |    223,188      100.00

. gen int_other_ind = r1009h == 1

. bysort urut: egen n_int_other = total(int_other_ind)

. gen int_other = n_int_other > 0

. summ int_other n_int_other

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   int_other |  1,109,749    .0222852    .1476096          0          1
 n_int_other |  1,109,749    .0334094    .2553389          0          8

. drop n_int_other int_other_ind

. 
. ** Energy
. tab r1514

      r1514 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    994,367       89.60       89.60
          2 |     54,122        4.88       94.48
          3 |     61,260        5.52      100.00
------------+-----------------------------------
      Total |  1,109,749      100.00

. gen PLNelectricity = r1514 == 1

. gen nonPLNelectricity = r1514 == 2

. gen nonelectricity = r1514 == 3

. summ *electricity

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
PLNelectri~y |  1,109,749    .8960287    .3052234          0          1
nonPLNelec~y |  1,109,749    .0487696    .2153861          0          1
nonelectri~y |  1,109,749    .0552017    .2283736          0          1

. 
. tab r1515

      r1515 |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      2,629        0.24        0.24
          1 |      5,030        0.45        0.69
          2 |      3,779        0.34        1.03
          3 |     64,738        5.83        6.86
          4 |    623,743       56.21       63.07
          5 |      2,812        0.25       63.32
          6 |     92,609        8.35       71.67
          7 |         42        0.00       71.67
          8 |      3,036        0.27       71.95
          9 |    310,346       27.97       99.91
         10 |        985        0.09      100.00
------------+-----------------------------------
      Total |  1,109,749      100.00

. gen electricity = r1515 == 1

. gen lpgas5kg = r1515 == 2

. gen lpgas12kg = r1515 == 3

. gen lpgas3kg = r1515 == 4

. gen gasorbiogas = r1515 == 5

. gen kerosene = r1515 == 6

. gen briquettecoal = r1515 == 7

. gen charcoal = r1515 == 8

. gen firewood = r1515 == 9

. gen otherenergy = r1515 == 10

. gen notcookingathome = r1515 == 0

. 
. // drop duplicates within household
. duplicates drop urut, force

Duplicates in terms of urut

(818,335 observations deleted)

. 
. gen urban = r105 == 1

. rename r101 PROVINSI

. rename r102 KABU

. drop r1* r2* r3* r4* r5* r6* r7* r8* r9* *lai *khir catatan food nfood expend fwt_tahun

. 
. order PROVINSI kabu urban urut, first

. // rename
. foreach var of var* {
  2.         rename `var' mar16_`var'
  3. }

. 
. rename *PROVINSI PROVINSI

. rename *kabu kabu

. rename *urban urban

. rename *urut urut

. drop *KABU

. rename *fwt fwt

. 
. // rename to match merge
. rename kabu id_jan14

. 
. tempfile sus16

. save `sus16', replace
(file /var/folders/23/7_md6wbn6ns7m_ppp9yb96sh0000gp/T//S_18300.000001 not found)
file /var/folders/23/7_md6wbn6ns7m_ppp9yb96sh0000gp/T//S_18300.000001 saved as .dta format

. 
. 
. 
. /*----------------------------------------------------*/
.    /* Section: Create Mar 2017 Baseline Variables */
. /*----------------------------------------------------*/
. 
. // load Mar 2017 household dataset
. u "$importable/susenas17mar_kor17rt_diseminasi.dta", clear

. 
. ** House variables
. rename r1601a n_hh_house

. tab n_hh_house

 n_hh_house |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    287,743       96.79       96.79
          2 |      6,781        2.28       99.07
          3 |      1,420        0.48       99.55
          4 |        550        0.19       99.74
          5 |        394        0.13       99.87
          6 |        168        0.06       99.93
          7 |        220        0.07      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. rename r1604 area

. tab area

       area |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |         11        0.00        0.00
          4 |         47        0.02        0.02
          5 |        104        0.03        0.05
          6 |        334        0.11        0.17
          7 |         73        0.02        0.19
          8 |        244        0.08        0.27
          9 |      1,058        0.36        0.63
         10 |        482        0.16        0.79
         11 |         80        0.03        0.82
         12 |      2,408        0.81        1.63
         13 |        140        0.05        1.68
         14 |        506        0.17        1.85
         15 |      1,526        0.51        2.36
         16 |      1,537        0.52        2.88
         17 |        161        0.05        2.93
         18 |      1,919        0.65        3.58
         19 |         94        0.03        3.61
         20 |      3,447        1.16        4.77
         21 |      1,156        0.39        5.16
         22 |        315        0.11        5.26
         23 |        127        0.04        5.30
         24 |      6,734        2.27        7.57
         25 |      1,571        0.53        8.10
         26 |        380        0.13        8.23
         27 |        640        0.22        8.44
         28 |      2,525        0.85        9.29
         29 |        107        0.04        9.33
         30 |      8,478        2.85       12.18
         31 |        128        0.04       12.22
         32 |      3,037        1.02       13.24
         33 |        240        0.08       13.32
         34 |        347        0.12       13.44
         35 |      7,858        2.64       16.08
         36 |      9,008        3.03       19.11
         37 |        230        0.08       19.19
         38 |        574        0.19       19.38
         39 |        308        0.10       19.49
         40 |      8,637        2.91       22.39
         41 |        262        0.09       22.48
         42 |     10,339        3.48       25.96
         43 |        258        0.09       26.05
         44 |        711        0.24       26.29
         45 |      5,447        1.83       28.12
         46 |        760        0.26       28.37
         47 |        385        0.13       28.50
         48 |     12,567        4.23       32.73
         49 |      1,634        0.55       33.28
         50 |      6,511        2.19       35.47
         51 |        341        0.11       35.59
         52 |        932        0.31       35.90
         53 |        230        0.08       35.98
         54 |     12,461        4.19       40.17
         55 |      1,611        0.54       40.71
         56 |      5,914        1.99       42.70
         57 |        373        0.13       42.82
         58 |        594        0.20       43.02
         59 |        313        0.11       43.13
         60 |     15,477        5.21       48.34
         61 |        164        0.06       48.39
         62 |        654        0.22       48.61
         63 |      6,899        2.32       50.93
         64 |      2,646        0.89       51.82
         65 |      1,428        0.48       52.30
         66 |      2,703        0.91       53.21
         67 |        264        0.09       53.30
         68 |        968        0.33       53.63
         69 |        422        0.14       53.77
         70 |      7,589        2.55       56.32
         71 |        208        0.07       56.39
         72 |     14,474        4.87       61.26
         73 |        231        0.08       61.34
         74 |        527        0.18       61.51
         75 |      2,485        0.84       62.35
         76 |        560        0.19       62.54
         77 |      2,182        0.73       63.27
         78 |      2,144        0.72       63.99
         79 |        213        0.07       64.07
         80 |      7,671        2.58       66.65
         81 |      1,218        0.41       67.06
         82 |        583        0.20       67.25
         83 |        281        0.09       67.35
         84 |      8,328        2.80       70.15
         85 |        799        0.27       70.42
         86 |        530        0.18       70.60
         87 |        281        0.09       70.69
         88 |      1,424        0.48       71.17
         89 |        208        0.07       71.24
         90 |      6,525        2.19       73.43
         91 |      1,346        0.45       73.89
         92 |        486        0.16       74.05
         93 |        225        0.08       74.13
         94 |        411        0.14       74.26
         95 |        431        0.14       74.41
         96 |      7,344        2.47       76.88
         97 |        196        0.07       76.94
         98 |      2,255        0.76       77.70
         99 |      1,237        0.42       78.12
        100 |      4,830        1.62       79.74
        101 |         94        0.03       79.78
        102 |        879        0.30       80.07
        103 |        123        0.04       80.11
        104 |      1,227        0.41       80.53
        105 |      2,715        0.91       81.44
        106 |        238        0.08       81.52
        107 |         96        0.03       81.55
        108 |      4,358        1.47       83.02
        109 |        132        0.04       83.06
        110 |      1,460        0.49       83.55
        111 |        135        0.05       83.60
        112 |      2,243        0.75       84.35
        113 |        104        0.03       84.39
        114 |        366        0.12       84.51
        115 |        308        0.10       84.61
        116 |        169        0.06       84.67
        117 |        761        0.26       84.93
        118 |        149        0.05       84.98
        119 |        373        0.13       85.10
        120 |      8,523        2.87       87.97
        121 |        155        0.05       88.02
        122 |        132        0.04       88.07
        123 |        115        0.04       88.11
        124 |        227        0.08       88.18
        125 |        545        0.18       88.37
        126 |      1,292        0.43       88.80
        127 |         84        0.03       88.83
        128 |        934        0.31       89.14
        129 |         77        0.03       89.17
        130 |        894        0.30       89.47
        131 |         54        0.02       89.49
        132 |        649        0.22       89.71
        133 |        173        0.06       89.76
        134 |         68        0.02       89.79
        135 |      1,239        0.42       90.20
        136 |        470        0.16       90.36
        137 |         56        0.02       90.38
        138 |        181        0.06       90.44
        139 |         47        0.02       90.46
        140 |      2,016        0.68       91.13
        141 |         46        0.02       91.15
        142 |        127        0.04       91.19
        143 |        207        0.07       91.26
        144 |      1,550        0.52       91.78
        145 |        119        0.04       91.82
        146 |         70        0.02       91.85
        147 |        140        0.05       91.89
        148 |        105        0.04       91.93
        149 |         39        0.01       91.94
        150 |      3,580        1.20       93.15
        151 |         29        0.01       93.16
        152 |        174        0.06       93.22
        153 |        215        0.07       93.29
        154 |        297        0.10       93.39
        155 |         79        0.03       93.41
        156 |        330        0.11       93.53
        157 |         42        0.01       93.54
        158 |         55        0.02       93.56
        159 |         23        0.01       93.57
        160 |      1,603        0.54       94.11
        161 |         80        0.03       94.13
        162 |        347        0.12       94.25
        163 |         35        0.01       94.26
        164 |         63        0.02       94.28
        165 |        276        0.09       94.37
        166 |         39        0.01       94.39
        167 |         26        0.01       94.40
        168 |        694        0.23       94.63
        169 |         57        0.02       94.65
        170 |        396        0.13       94.78
        171 |         83        0.03       94.81
        172 |         63        0.02       94.83
        173 |         26        0.01       94.84
        174 |         51        0.02       94.86
        175 |        235        0.08       94.94
        176 |        211        0.07       95.01
        177 |         26        0.01       95.02
        178 |         31        0.01       95.03
        179 |         17        0.01       95.03
        180 |      1,868        0.63       95.66
        181 |         22        0.01       95.67
        182 |        161        0.05       95.72
        183 |         24        0.01       95.73
        184 |         84        0.03       95.76
        185 |         59        0.02       95.78
        186 |         40        0.01       95.79
        187 |         67        0.02       95.81
        188 |         35        0.01       95.83
        189 |         81        0.03       95.85
        190 |        174        0.06       95.91
        191 |         14        0.00       95.92
        192 |        503        0.17       96.09
        193 |          5        0.00       96.09
        194 |         21        0.01       96.09
        195 |        148        0.05       96.14
        196 |        169        0.06       96.20
        197 |         21        0.01       96.21
        198 |        152        0.05       96.26
        199 |          8        0.00       96.26
        200 |      2,494        0.84       97.10
        201 |          8        0.00       97.10
        202 |         21        0.01       97.11
        203 |         19        0.01       97.12
        204 |        130        0.04       97.16
        205 |         27        0.01       97.17
        206 |         18        0.01       97.18
        207 |         49        0.02       97.19
        208 |        103        0.03       97.23
        209 |         13        0.00       97.23
        210 |        411        0.14       97.37
        211 |          7        0.00       97.37
        212 |         20        0.01       97.38
        213 |         15        0.01       97.38
        214 |         23        0.01       97.39
        215 |         40        0.01       97.41
        216 |        272        0.09       97.50
        217 |         20        0.01       97.50
        218 |         15        0.01       97.51
        219 |         11        0.00       97.51
        220 |        322        0.11       97.62
        221 |         30        0.01       97.63
        222 |         12        0.00       97.63
        223 |          7        0.00       97.64
        224 |        117        0.04       97.68
        225 |        304        0.10       97.78
        226 |         10        0.00       97.78
        227 |          9        0.00       97.78
        228 |         46        0.02       97.80
        229 |          2        0.00       97.80
        230 |         98        0.03       97.83
        231 |         24        0.01       97.84
        232 |         18        0.01       97.85
        233 |          8        0.00       97.85
        234 |         60        0.02       97.87
        235 |         17        0.01       97.88
        236 |         18        0.01       97.88
        237 |          4        0.00       97.88
        238 |         44        0.01       97.90
        239 |          1        0.00       97.90
        240 |        753        0.25       98.15
        241 |          6        0.00       98.15
        242 |         43        0.01       98.17
        243 |         24        0.01       98.18
        244 |         14        0.00       98.18
        245 |         15        0.01       98.19
        246 |         13        0.00       98.19
        247 |         23        0.01       98.20
        248 |         16        0.01       98.20
        249 |         10        0.00       98.21
        250 |        554        0.19       98.39
        251 |          5        0.00       98.40
        252 |         85        0.03       98.42
        253 |         22        0.01       98.43
        254 |          8        0.00       98.43
        255 |         49        0.02       98.45
        256 |         48        0.02       98.47
        257 |          5        0.00       98.47
        258 |          7        0.00       98.47
        259 |          6        0.00       98.47
        260 |        145        0.05       98.52
        261 |          8        0.00       98.52
        262 |          4        0.00       98.53
        263 |          4        0.00       98.53
        264 |         80        0.03       98.55
        265 |          9        0.00       98.56
        266 |         21        0.01       98.56
        267 |          5        0.00       98.57
        268 |          9        0.00       98.57
        269 |          4        0.00       98.57
        270 |        175        0.06       98.63
        271 |          3        0.00       98.63
        272 |         31        0.01       98.64
        273 |          7        0.00       98.64
        274 |          4        0.00       98.64
        275 |         66        0.02       98.67
        276 |         28        0.01       98.68
        277 |          3        0.00       98.68
        278 |          9        0.00       98.68
        279 |          6        0.00       98.68
        280 |        264        0.09       98.77
        281 |          3        0.00       98.77
        282 |          5        0.00       98.77
        283 |          9        0.00       98.78
        284 |          8        0.00       98.78
        285 |         33        0.01       98.79
        286 |         16        0.01       98.80
        287 |          3        0.00       98.80
        288 |        119        0.04       98.84
        289 |          6        0.00       98.84
        290 |         27        0.01       98.85
        291 |          2        0.00       98.85
        292 |          4        0.00       98.85
        293 |          2        0.00       98.85
        294 |         15        0.01       98.86
        295 |          9        0.00       98.86
        296 |         11        0.00       98.86
        297 |         14        0.00       98.87
        298 |         13        0.00       98.87
        299 |         12        0.00       98.88
        300 |      1,134        0.38       99.26
        301 |          3        0.00       99.26
        302 |          3        0.00       99.26
        303 |          1        0.00       99.26
        304 |          6        0.00       99.26
        305 |          5        0.00       99.26
        306 |         18        0.01       99.27
        307 |          1        0.00       99.27
        308 |         14        0.00       99.27
        309 |          2        0.00       99.27
        310 |         18        0.01       99.28
        311 |          1        0.00       99.28
        312 |         23        0.01       99.29
        313 |          1        0.00       99.29
        314 |          5        0.00       99.29
        315 |         36        0.01       99.30
        316 |          2        0.00       99.30
        317 |          4        0.00       99.31
        318 |          2        0.00       99.31
        319 |          5        0.00       99.31
        320 |         89        0.03       99.34
        321 |          2        0.00       99.34
        322 |          7        0.00       99.34
        323 |          5        0.00       99.34
        324 |         19        0.01       99.35
        325 |         38        0.01       99.36
        326 |          1        0.00       99.36
        327 |          2        0.00       99.36
        328 |          5        0.00       99.36
        330 |         51        0.02       99.38
        331 |          1        0.00       99.38
        332 |          3        0.00       99.38
        333 |          3        0.00       99.38
        334 |          3        0.00       99.38
        335 |          3        0.00       99.39
        336 |         17        0.01       99.39
        338 |          7        0.00       99.39
        339 |          1        0.00       99.39
        340 |         45        0.02       99.41
        341 |          1        0.00       99.41
        342 |          4        0.00       99.41
        343 |          1        0.00       99.41
        344 |          2        0.00       99.41
        345 |          7        0.00       99.41
        346 |          2        0.00       99.41
        348 |          4        0.00       99.42
        350 |        119        0.04       99.46
        351 |          2        0.00       99.46
        352 |          9        0.00       99.46
        354 |          2        0.00       99.46
        355 |          1        0.00       99.46
        356 |          2        0.00       99.46
        357 |          5        0.00       99.46
        358 |          1        0.00       99.46
        360 |        146        0.05       99.51
        361 |          3        0.00       99.51
        362 |          3        0.00       99.51
        363 |          2        0.00       99.52
        364 |          8        0.00       99.52
        365 |          7        0.00       99.52
        368 |          1        0.00       99.52
        369 |          1        0.00       99.52
        370 |          9        0.00       99.52
        372 |          2        0.00       99.52
        374 |          6        0.00       99.53
        375 |         71        0.02       99.55
        376 |          1        0.00       99.55
        378 |         10        0.00       99.55
        379 |          1        0.00       99.55
        380 |         29        0.01       99.56
        381 |          1        0.00       99.56
        382 |          2        0.00       99.57
        384 |          9        0.00       99.57
        385 |          5        0.00       99.57
        386 |          1        0.00       99.57
        387 |          2        0.00       99.57
        388 |          4        0.00       99.57
        389 |          1        0.00       99.57
        390 |         21        0.01       99.58
        392 |          2        0.00       99.58
        393 |          2        0.00       99.58
        394 |          1        0.00       99.58
        395 |          2        0.00       99.58
        396 |         15        0.01       99.59
        397 |          1        0.00       99.59
        398 |          1        0.00       99.59
        399 |          4        0.00       99.59
        400 |        281        0.09       99.68
        403 |          1        0.00       99.68
        404 |          1        0.00       99.68
        405 |         11        0.00       99.69
        406 |          3        0.00       99.69
        408 |          7        0.00       99.69
        409 |          1        0.00       99.69
        410 |          6        0.00       99.69
        412 |          2        0.00       99.69
        413 |          2        0.00       99.70
        414 |          6        0.00       99.70
        415 |          5        0.00       99.70
        416 |          2        0.00       99.70
        420 |         33        0.01       99.71
        421 |          1        0.00       99.71
        422 |          2        0.00       99.71
        423 |          3        0.00       99.71
        425 |          6        0.00       99.71
        427 |          2        0.00       99.72
        428 |          4        0.00       99.72
        429 |          3        0.00       99.72
        430 |          3        0.00       99.72
        431 |          1        0.00       99.72
        432 |          9        0.00       99.72
        433 |          2        0.00       99.72
        434 |          1        0.00       99.72
        435 |          1        0.00       99.72
        438 |          1        0.00       99.72
        439 |          1        0.00       99.72
        440 |         15        0.01       99.73
        441 |          3        0.00       99.73
        442 |          5        0.00       99.73
        443 |          1        0.00       99.73
        444 |          1        0.00       99.73
        445 |          3        0.00       99.73
        447 |          1        0.00       99.73
        448 |          3        0.00       99.73
        449 |          2        0.00       99.74
        450 |        103        0.03       99.77
        452 |          1        0.00       99.77
        453 |          2        0.00       99.77
        455 |          1        0.00       99.77
        456 |          3        0.00       99.77
        458 |          1        0.00       99.77
        459 |          1        0.00       99.77
        460 |         12        0.00       99.78
        462 |          2        0.00       99.78
        464 |          1        0.00       99.78
        465 |          1        0.00       99.78
        466 |          1        0.00       99.78
        468 |          2        0.00       99.78
        470 |          6        0.00       99.78
        475 |          4        0.00       99.78
        476 |          1        0.00       99.78
        480 |         38        0.01       99.80
        481 |          1        0.00       99.80
        483 |          1        0.00       99.80
        484 |          2        0.00       99.80
        486 |          3        0.00       99.80
        488 |          1        0.00       99.80
        489 |          1        0.00       99.80
        490 |          4        0.00       99.80
        492 |          2        0.00       99.80
        495 |          7        0.00       99.80
        496 |          1        0.00       99.80
        497 |          1        0.00       99.80
        498 |          1        0.00       99.80
        500 |        102        0.03       99.84
        501 |          1        0.00       99.84
        503 |          1        0.00       99.84
        504 |          2        0.00       99.84
        505 |          2        0.00       99.84
        506 |          1        0.00       99.84
        508 |          1        0.00       99.84
        510 |          7        0.00       99.84
        512 |          2        0.00       99.84
        513 |          1        0.00       99.84
        516 |          1        0.00       99.85
        518 |          1        0.00       99.85
        520 |         11        0.00       99.85
        522 |          2        0.00       99.85
        523 |          2        0.00       99.85
        524 |          1        0.00       99.85
        525 |         12        0.00       99.86
        526 |          1        0.00       99.86
        528 |          2        0.00       99.86
        530 |          1        0.00       99.86
        535 |          2        0.00       99.86
        540 |         16        0.01       99.86
        543 |          1        0.00       99.86
        545 |          2        0.00       99.86
        546 |          2        0.00       99.86
        547 |          2        0.00       99.86
        550 |          7        0.00       99.87
        552 |          1        0.00       99.87
        553 |          1        0.00       99.87
        554 |          1        0.00       99.87
        556 |          1        0.00       99.87
        558 |          1        0.00       99.87
        560 |         14        0.00       99.87
        564 |          4        0.00       99.87
        570 |          2        0.00       99.88
        573 |          1        0.00       99.88
        575 |          2        0.00       99.88
        576 |          4        0.00       99.88
        580 |          3        0.00       99.88
        585 |          2        0.00       99.88
        588 |          3        0.00       99.88
        595 |          4        0.00       99.88
        596 |          1        0.00       99.88
        597 |          1        0.00       99.88
        600 |        104        0.03       99.92
        601 |          1        0.00       99.92
        602 |          3        0.00       99.92
        605 |          3        0.00       99.92
        607 |          1        0.00       99.92
        610 |          2        0.00       99.92
        615 |          1        0.00       99.92
        616 |          2        0.00       99.92
        618 |          1        0.00       99.92
        620 |          2        0.00       99.92
        625 |          5        0.00       99.92
        628 |          2        0.00       99.93
        630 |          7        0.00       99.93
        632 |          1        0.00       99.93
        636 |          2        0.00       99.93
        640 |          2        0.00       99.93
        645 |          1        0.00       99.93
        650 |         16        0.01       99.94
        652 |          1        0.00       99.94
        660 |          3        0.00       99.94
        663 |          2        0.00       99.94
        666 |          1        0.00       99.94
        670 |          1        0.00       99.94
        673 |          1        0.00       99.94
        675 |          5        0.00       99.94
        680 |          1        0.00       99.94
        683 |          1        0.00       99.94
        689 |          1        0.00       99.94
        696 |          1        0.00       99.94
        700 |         23        0.01       99.95
        701 |          1        0.00       99.95
        702 |          2        0.00       99.95
        710 |          2        0.00       99.95
        712 |          1        0.00       99.95
        713 |          1        0.00       99.95
        720 |          8        0.00       99.95
        722 |          1        0.00       99.95
        725 |          4        0.00       99.96
        732 |          1        0.00       99.96
        735 |          1        0.00       99.96
        740 |          3        0.00       99.96
        743 |          1        0.00       99.96
        744 |          1        0.00       99.96
        745 |          1        0.00       99.96
        750 |         15        0.01       99.96
        753 |          1        0.00       99.96
        754 |          1        0.00       99.96
        760 |          3        0.00       99.97
        765 |          1        0.00       99.97
        768 |          1        0.00       99.97
        773 |          1        0.00       99.97
        775 |          1        0.00       99.97
        780 |          1        0.00       99.97
        781 |          1        0.00       99.97
        787 |          1        0.00       99.97
        800 |         31        0.01       99.98
        801 |          1        0.00       99.98
        805 |          1        0.00       99.98
        808 |          1        0.00       99.98
        809 |          2        0.00       99.98
        810 |          4        0.00       99.98
        815 |          1        0.00       99.98
        816 |          1        0.00       99.98
        820 |          2        0.00       99.98
        825 |          4        0.00       99.98
        830 |          1        0.00       99.98
        840 |          3        0.00       99.98
        842 |          1        0.00       99.99
        845 |          1        0.00       99.99
        847 |          1        0.00       99.99
        860 |          1        0.00       99.99
        861 |          1        0.00       99.99
        870 |          1        0.00       99.99
        871 |          1        0.00       99.99
        880 |          3        0.00       99.99
        896 |          1        0.00       99.99
        900 |         12        0.00       99.99
        901 |          1        0.00       99.99
        905 |          1        0.00       99.99
        910 |          2        0.00       99.99
        920 |          2        0.00       99.99
        930 |          1        0.00       99.99
        931 |          1        0.00      100.00
        945 |          2        0.00      100.00
        960 |          3        0.00      100.00
        961 |          1        0.00      100.00
        975 |          2        0.00      100.00
        979 |          1        0.00      100.00
        996 |          1        0.00      100.00
        997 |          4        0.00      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. 
. tab r1602

      r1602 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    243,138       81.79       81.79
          2 |     21,746        7.32       89.10
          3 |     26,466        8.90       98.01
          4 |      5,259        1.77       99.78
          5 |        667        0.22      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen ownhouse = r1602 == 1

. gen lease = r1602 == 2

. gen freelease = r1602 == 3

. gen companyhouse = r1602 == 4

. gen otherhouse = r1602 == 5

. 
. tab r1607

      r1607 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      3,805        1.28        1.28
          2 |    111,691       37.57       38.85
          3 |     21,398        7.20       46.05
          4 |    148,158       49.84       95.89
          5 |        340        0.11       96.00
          6 |      2,398        0.81       96.81
          7 |      9,069        3.05       99.86
          8 |        417        0.14      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen concreteroof = r1607 == 1

. gen tileroof = r1607 == 2

. gen asbestosroof = r1607 == 3

. gen ironsheetroof = r1607 == 4

. gen bambooroof = r1607 == 5

. gen shinglewoodroof = r1607 == 6

. gen fiberpalmroof = r1607 == 7

. gen otherroof = r1607 == 8

. 
. tab r1608

      r1608 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    191,674       64.48       64.48
          2 |      4,171        1.40       65.88
          3 |     82,568       27.77       93.65
          4 |      8,637        2.91       96.56
          5 |      1,090        0.37       96.93
          6 |      3,625        1.22       98.15
          7 |      5,511        1.85      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen concretewall = r1608 == 1

. gen wovenbamboowall = r1608 == 2

. gen woodwall = r1608 == 3

. gen wovenwoodwall = r1608 == 4

. gen logwoodwall = r1608 == 5

. gen bamboowall = r1608 == 6

. gen otherwall = r1608 == 7

. 
. tab r1609

      r1609 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      2,961        1.00        1.00
          2 |    111,908       37.64       38.64
          3 |        520        0.17       38.82
          4 |     15,286        5.14       43.96
          5 |     47,819       16.09       60.04
          6 |    100,241       33.72       93.76
          7 |      2,367        0.80       94.56
          8 |     15,692        5.28       99.84
          9 |        482        0.16      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen marblegranitefloor = r1609 == 1

. gen ceramicfloor = r1609 == 2

. gen parquettevinylfloor = r1609 == 3

. gen tilefloor = r1609 == 4

. gen highqualitywoodfloor = r1609 == 5

. gen cementbrickfloor = r1609 == 6

. gen bamboofloor = r1609 == 7

. gen soilfloor = r1609 == 8

. gen otherfloor = r1609 == 9

. 
. ** Toilet variables
. tab r1610a

     r1610a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    226,263       76.11       76.11
          2 |     24,879        8.37       84.48
          3 |      9,480        3.19       87.67
          4 |        392        0.13       87.80
          5 |     36,262       12.20      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen personaltoilet = r1610a == 1

. gen mutualtoilet = r1610a == 2

. gen communaltoilet = r1610a == 3

. gen notusetoilet = r1610a == 4

. gen noaccesstotoilet = r1610a == 5

. 
. tab r1610b

     r1610b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    227,337       90.52       90.52
          2 |      3,176        1.26       91.79
          3 |      4,497        1.79       93.58
          4 |     16,132        6.42      100.00
------------+-----------------------------------
      Total |    251,142      100.00

. gen goosetoilet = r1610b == 1

. gen  byte closedpitttoilet = r1610b == 2

. gen unclosedpitttoilet = r1610b == 3

. gen squattoilet = r1610b == 4

. gen notoilet = r1610b == .

. 
. tab r1610a r1610b

           |                   r1610b
    r1610a |         1          2          3          4 |     Total
-----------+--------------------------------------------+----------
         1 |   207,027      2,787      3,978     12,471 |   226,263 
         2 |    20,310        389        519      3,661 |    24,879 
-----------+--------------------------------------------+----------
     Total |   227,337      3,176      4,497     16,132 |   251,142 

. gen personalgoosetoilet = personaltoilet * goosetoilet

. gen personalclosedpitttoilet = personaltoilet * closedpitttoilet

. gen personalunclosedpitttoilet = personaltoilet * unclosedpitttoilet

. gen personalsquattoilet = personaltoilet * squattoilet

. 
. gen mutualgoosetoilet = mutualtoilet * goosetoilet

. gen mutualclosedpitttoilet = mutualtoilet * closedpitttoilet

. gen mutualunclosedpitttoilet = mutualtoilet * unclosedpitttoilet

. gen mutualsquattoilet = mutualtoilet * squattoilet

. 
. 
. ** Asset vars
. gen lpg5kgmore  = r2201a == 1

. gen refrigerator = r2201b == 1

. gen airconditioner = r2201c == 1

. gen waterheater = r2201d == 1

. gen landline = r2201e == 1

. gen computer = r2201f == 1

. gen goldjewelerymin10gram = r2201g == 1

. gen motorcycle = r2201h == 1

. gen boat = r2201i == 1

. gen motorboat = r2201j == 1

. gen car = r2201k == 1

. summ lpg5kgmore refrigerator airconditioner waterheater landline computer goldjewelerymin10gram motorcycle boat motorboat
>  car

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  lpg5kgmore |    297,276    .0955341    .2939518          0          1
refrigerator |    297,276    .5078883    .4999386          0          1
airconditi~r |    297,276    .0680546      .25184          0          1
 waterheater |    297,276    .0174417    .1309105          0          1
    landline |    297,276    .0255621    .1578251          0          1
-------------+---------------------------------------------------------
    computer |    297,276    .1818108    .3856892          0          1
goldjewele~m |    297,276    .1917477    .3936763          0          1
  motorcycle |    297,276    .7095393    .4539758          0          1
        boat |    297,276    .0262786    .1599629          0          1
   motorboat |    297,276    .0210377    .1435102          0          1
-------------+---------------------------------------------------------
         car |    297,276    .1026824    .3035441          0          1

. 
. ** Water vars
. tab r1610d

     r1610d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    188,929       75.23       75.23
          2 |      2,051        0.82       76.04
          3 |     16,612        6.61       82.66
          4 |     41,123       16.37       99.03
          5 |      1,482        0.59       99.62
          6 |        945        0.38      100.00
------------+-----------------------------------
      Total |    251,142      100.00

. gen septicdisposal = r1610d == 1

. gen pooldisposal = r1610d == 2

. gen riverdisposal = r1610d == 3

. gen pitholedisposal = r1610d == 4

. gen opendisposal = r1610d == 5

. gen otherdisposal = r1610d == 6

. 
. tab r1611a

     r1611a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     18,897        6.36        6.36
          2 |     71,450       24.03       30.39
          3 |     33,386       11.23       41.62
          4 |     38,136       12.83       54.45
          5 |     54,695       18.40       72.85
          6 |     19,163        6.45       79.30
          7 |     29,638        9.97       89.27
          8 |     11,675        3.93       93.19
          9 |      7,224        2.43       95.62
         10 |     12,913        4.34       99.97
         11 |         99        0.03      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen bottleddrinkwater = r1611a == 1

. gen refilldrinkwater = r1611a == 2

. gen tapdrinkwater = r1611a == 3

. gen pumpdrinkwater = r1611a == 4

. gen protwelldrinkwater = r1611a == 5

. gen unprotwelldrinkwater = r1611a == 6

. gen protspringdrinkwater = r1611a == 7

. gen unprotspringdrinkwater = r1611a == 8

. gen riverdrinkwater = r1611a == 9

. gen raindrinkwater = r1611a == 10

. gen otherdrinkwater = r1611a == 11

. 
. tab r1616a

     r1616a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        604        0.20        0.20
          2 |      1,569        0.53        0.73
          3 |     54,747       18.42       19.15
          4 |     71,120       23.92       43.07
          5 |     76,760       25.82       68.89
          6 |     26,312        8.85       77.74
          7 |     28,928        9.73       87.47
          8 |     11,799        3.97       91.44
          9 |     17,574        5.91       97.35
         10 |      7,569        2.55       99.90
         11 |        294        0.10      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen bottledcookwater = r1616a == 1

. gen refillcookwater = r1616a == 2

. gen tapcookwater = r1616a == 3

. gen pumpcookwater = r1616a == 4

. gen protectedwellcookwater = r1616a == 5

. gen unprotectedwellcookwater = r1616a == 6

. gen protectedspringcookwater = r1616a == 7

. gen unprotectedspringcookwater = r1616a == 8

. gen rivercookwater = r1616a == 9

. gen raincookwater = r1616a == 10

. gen othercookwater = r1616a == 11

. 
. tab r1611a

     r1611a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     18,897        6.36        6.36
          2 |     71,450       24.03       30.39
          3 |     33,386       11.23       41.62
          4 |     38,136       12.83       54.45
          5 |     54,695       18.40       72.85
          6 |     19,163        6.45       79.30
          7 |     29,638        9.97       89.27
          8 |     11,675        3.93       93.19
          9 |      7,224        2.43       95.62
         10 |     12,913        4.34       99.97
         11 |         99        0.03      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. tab r1611b

     r1611b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     43,221       28.19       28.19
          2 |     95,854       62.52       90.72
          8 |     14,232        9.28      100.00
------------+-----------------------------------
      Total |    153,307      100.00

. gen cleandrinkwater = r1611b
(143,969 missing values generated)

. replace cleandrinkwater = 0 if cleandrinkwater != .
(153,307 real changes made)

. replace cleandrinkwater = 1 if inlist(r1611a, 1, 2, 3, 9, 10, 11)
(143,969 real changes made)

. 
. tab r1616b

     r1616b |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     67,945       31.61       31.61
          2 |    127,268       59.22       90.83
          8 |     19,706        9.17      100.00
------------+-----------------------------------
      Total |    214,919      100.00

. tab r1616a

     r1616a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        604        0.20        0.20
          2 |      1,569        0.53        0.73
          3 |     54,747       18.42       19.15
          4 |     71,120       23.92       43.07
          5 |     76,760       25.82       68.89
          6 |     26,312        8.85       77.74
          7 |     28,928        9.73       87.47
          8 |     11,799        3.97       91.44
          9 |     17,574        5.91       97.35
         10 |      7,569        2.55       99.90
         11 |        294        0.10      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen cleancookwater = r1616b
(82,357 missing values generated)

. replace cleancookwater = 0  if cleancookwater != .
(214,919 real changes made)

. replace cleancookwater = 1 if inlist(r1616a, 1, 2, 3, 9, 10, 11)
(82,357 real changes made)

. 
. 
. ** Energy vars
. tab r1618a

     r1618a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    243,349       81.86       81.86
          2 |     27,223        9.16       91.02
          3 |     13,437        4.52       95.54
          5 |     13,267        4.46      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen PLNelectricity = r1618a == 1 | r1618a == 2

. gen nonPLNelectricity = r1618a == 3

. gen nonelectricity = r1618a == 5

. 
. tab r1619

      r1619 |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      3,893        1.31        1.31
          1 |      1,386        0.47        1.78
          2 |      1,397        0.47        2.25
          3 |     15,657        5.27        7.51
          4 |    179,614       60.42       67.93
          5 |        801        0.27       68.20
          6 |         28        0.01       68.21
          7 |     23,757        7.99       76.20
          8 |          2        0.00       76.20
          9 |        536        0.18       76.38
         10 |     70,117       23.59       99.97
         11 |         88        0.03      100.00
------------+-----------------------------------
      Total |    297,276      100.00

. gen electricity = r1619 == 1

. gen lpgas5kg = r1619 == 2

. gen lpgas12kg = r1619 == 3

. gen lpgas3kg = r1619 == 4

. gen gasorbiogas = r1619 == 5 | r1619 == 6

. gen kerosene = r1619 == 7

. gen briquettecoal = r1619 == 8

. gen charcoal = r1619 == 9

. gen firewood = r1619 == 10

. gen otherenergy = r1619 == 11

. gen notcookingathome = r1619 == 0

. 
. *** Variables from individual survey
. merge 1:m renum using "$importable/susenas17mar_kor17ind_a_diseminasi.dta"

    Result                      Number of obs
    -----------------------------------------
    Not matched                             0
    Matched                         1,132,749  (_merge==3)
    -----------------------------------------

. assert _m == 3

. drop _m

. 
. ** Demographic variables
. gen male = r405 == 1

. bysort renum: egen totalmale = total(male)

. drop male

. 
. gen female = r405 == 2

. bysort renum: egen totalfemale = total(female)

. drop female

. 
. gen child = r403 == 3

. bysort renum: egen totalchild = total(child)

. drop child

. 
. summ totalmale totalfemale totalchild

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   totalmale |  1,132,749    2.309351    1.257382          0         16
 totalfemale |  1,132,749    2.269149    1.203744          0         14
  totalchild |  1,132,749    2.013268    1.378926          0         12

. 
. ** Telecommunication
. 
. gen cell = r702 == 1

. bysort renum: egen n_cell_hh = total(cell)

. gen own_cell = n_cell_hh > 0

. summ n_cell_hh own_cell

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   n_cell_hh |  1,132,749    2.265976    1.461521          0         15
    own_cell |  1,132,749    .9084643    .2883696          0          1

. 
. gen computeruse = r703 == 1

. bysort renum: egen n_computer_hh = total(computeruse)

. gen usecomputer = n_computer_hh > 0

. summ n_computer_hh usecomputer

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
n_computer~h |  1,132,749    .7311664    1.198538          0         15
 usecomputer |  1,132,749    .3735867     .483756          0          1

. 
. gen internet = r704 == 1

. bysort renum: egen n_internet_hh = total(internet)

. gen useinternet = n_internet_hh > 0

. summ useinternet n_internet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 useinternet |  1,132,749    .5587813     .496533          0          1
n_internet~h |  1,132,749    1.147482    1.354011          0         15

. drop internet

. 
. gen homeinter = !missing(r706_a)

. bysort renum: egen n_homeinternet_hh = total(homeinter)

. gen homeinternet = n_homeinternet_hh > 0

. summ homeinternet n_homeinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
homeinternet |  1,132,749    .4992209    .4999996          0          1
n_homeinte~h |  1,132,749    1.024539    1.323433          0         15

. drop homeinter

. 
. gen notownint = !missing(r706_b)

. bysort renum: egen n_notownhomeinternet_hh = total(notownint)

. gen notownhomeinternet = n_notownhomeinternet_hh > 0

. summ n_notownhomeinternet_hh notownhomeinternet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
n_notownho~h |  1,132,749    .3215373    .8095053          0         10
notownhome~t |  1,132,749    .1820015    .3858459          0          1

. drop notownint

. 
. gen officeint = !missing(r706_c)

. bysort renum: egen n_officeinternet_hh = total(officeint)

. gen officeinternet = n_officeinternet_hh > 0

. summ officeinternet n_officeinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
officeinte~t |  1,132,749    .2040196    .4029836          0          1
n_officein~h |  1,132,749    .2972591    .6743396          0         10

. drop officeint

. 
. gen schoolint = !missing(r706_d)

. bysort renum: egen n_schoolinternet_hh = total(schoolint)

. gen schoolinternet = n_schoolinternet_hh > 0

. summ schoolinternet n_schoolinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
schoolinte~t |  1,132,749    .1642756    .3705256          0          1
n_schoolin~h |  1,132,749    .2143317    .5435607          0         10

. drop schoolint

. 
. gen publicint_ind = !missing(r706_e)

. bysort renum: egen n_publicinternet_hh = total(publicint_ind)

. gen publicinternet = n_publicinternet_hh > 0

. summ publicinternet n_publicinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
publicinte~t |  1,132,749    .1311667    .3375828          0          1
n_publicin~h |  1,132,749    .2243595    .6778278          0         11

. drop publicint_ind

. 
. gen vehicleinternet_ind = !missing(r706_g)

. bysort renum: egen n_vehicleinternet_hh = total(vehicleinternet_ind)

. gen vehicleinternet = n_vehicleinternet_hh > 0

. summ vehicleinternet n_vehicleinternet_hh

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
vehicleint~t |  1,132,749     .093055    .2905097          0          1
n_vehiclei~h |  1,132,749    .1715579    .6305947          0         11

. drop vehicleinternet_ind

. 
. gen int_gettinginformation_ind = !missing(r707_a)

. bysort renum: egen n_int_gettinginformation = total(int_gettinginformation_ind)

. gen int_gettinginformation = n_int_gettinginformation > 0

. summ int_gettinginformation

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_gettin~n |  1,132,749    .3896309    .4876668          0          1

. drop int_gettinginformation_ind n_int_gettinginformation

. 
. gen int_dohomework_ind = !missing(r707_b)

. bysort renum: egen n_int_dohomework = total(int_dohomework_ind)

. gen int_dohomework = n_int_dohomework > 0

. summ int_dohomework

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_dohome~k |  1,132,749    .2420907    .4283491          0          1

. drop int_dohomework_ind n_int_dohomework

. 
. gen int_email_ind = !missing(r707_c)

. bysort renum: egen n_int_email = total(int_email_ind)

. gen int_email = n_int_email > 0

. summ int_email

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   int_email |  1,132,749    .1355208    .3422791          0          1

. drop n_int_email

. 
. gen int_socialmedia_ind = !missing(r707_d)

. bysort renum: egen n_int_socialmedia = total(int_socialmedia_ind)

. gen int_socialmedia = n_int_socialmedia > 0

. summ int_socialmedia

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_social~a |  1,132,749    .4538278    .4978638          0          1

. drop n_int_socialmedia

. 
. gen int_buysellservice_ind = !missing(r707_e) | !missing(r707_f)

. bysort renum: egen n_int_buysellservice_ind = total(int_buysellservice_ind)

. gen int_buysellservice = n_int_buysellservice_ind > 0

. summ int_buysellservice

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_buysel~e |  1,132,749    .0726887    .2596249          0          1

. drop n_int_buysellservice_ind int_buysellservice_ind

. 
. gen int_recreational_ind = !missing(r707_g)

. bysort renum: egen n_int_recreational = total(int_recreational_ind)

. gen int_recreational = n_int_recreational > 0

. summ int_recreational

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_recrea~l |  1,132,749    .2855487    .4516756          0          1

. drop int_recreational_ind n_int_recreational

. 
. gen int_financial_ind = !missing(r707_h)

. bysort renum: egen n_int_financial = total(int_financial_ind)

. gen int_financial = n_int_financial > 0

. summ int_financial

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
int_financ~l |  1,132,749    .0298725    .1702355          0          1

. drop int_financial_ind n_int_financial

. 
. gen int_other_ind = !missing(r707_j)

. bysort renum: egen n_int_other = total(int_other_ind)

. gen int_other = n_int_other > 0

. summ int_other

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   int_other |  1,132,749    .0117881    .1079314          0          1

. drop int_other_ind n_int_other

. 
. 
. duplicates drop renum, force

Duplicates in terms of renum

(835,473 observations deleted)

. 
. ** monthly per capita expenditure
. rename exp_cap month_pcexp

. summ month_pcexp

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 month_pcexp |    297,276     1096917     1022073   88970.24   4.89e+07

. // tostring PROVINSI, replace
. // tostring KABU, replace
. 
. rename r101 PROVINSI

. rename r102 KABU

. gen urban = r105 == 1

. 
. // Create kabu code
. tostring PROVINSI, replace
PROVINSI was byte now str2

. tostring KABU, replace
KABU was byte now str2

. gen zero = "0"

. replace KABU = zero + KABU if inlist(KABU, "1", "2", "3", "4", "5", "6", "7", "8", "9")
(148,764 real changes made)

. gen kabu = PROVINSI + KABU

. drop KABU

. drop zero

. destring kabu, replace
kabu: all characters numeric; replaced as int

. 
. 
. drop r1* r2* r3* r4* r5* r6* r7* r8* r9* r*1* r*2* r*3* r*4* nu* catatan *lai rjam* rmen* *food expend

. 
. 
. foreach var of var* {
  2.         rename `var' mar17_`var'
  3. }

. rename *PROVINSI PROVINSI

. rename *kabu kabu

. rename *urut urut

. rename *fwt fwt

. rename *urban urban

. 
. 
. * address split districts
. gen id_mar17 = kabu

. rename kabu id_jan14

. replace id_jan14 = 7402 if id_jan14 == 7413 // Muna Barat, split from Muna
(130 real changes made)

. replace id_jan14 = 7401 if id_jan14 == 7414 // Buton Tengah, split from Buton
(180 real changes made)

. replace id_jan14 = 7401 if id_jan14 == 7415 // Buton Selatan, split from Buton
(130 real changes made)

. 
. tempfile sus17

. save `sus17'
file /var/folders/23/7_md6wbn6ns7m_ppp9yb96sh0000gp/T//S_18300.000002 saved as .dta format

. 
. /*----------------------------------------------------*/
.    /* Section: Create Mar 2018 Baseline Variables */
. /*----------------------------------------------------*/
. 
. // load Mar 2018 household dataset
. u "${importable}/kor18rt_diseminasi.dta", clear

. 
. 
. *** Household characteristics
. di _N
295155

. summ R1501A

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
      R1501A |    295,155    1.078769    .4354406          1          7

. rename R1501A nhhhouse

. rename R1504 area

. tab R1801A

     R1801A |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     30,943       10.48       10.48
          5 |    264,212       89.52      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. 
. *** Asset variables
. gen lpg5kgmore = R1801A == 1

. tab R1801B

     R1801B |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    154,536       52.36       52.36
          5 |    140,619       47.64      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen regiferator  = R1801B == 1

. tab R1801C

     R1801C |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     21,012        7.12        7.12
          5 |    274,143       92.88      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen airconditioner = R1801C == 1

. tab R1801D

     R1801D |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      5,732        1.94        1.94
          5 |    289,423       98.06      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen waterheater = R1801D == 1

. tab R1801E

     R1801E |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      5,873        1.99        1.99
          5 |    289,282       98.01      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen landline = R1801E == 1

. tab R1801F

     R1801F |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     55,322       18.74       18.74
          5 |    239,833       81.26      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen computer = R1801F == 1

. tab R1801G

     R1801G |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     51,994       17.62       17.62
          5 |    243,161       82.38      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen goldjewelerymin10gram = R1801G == 1

. tab R1801H

     R1801H |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    213,248       72.25       72.25
          5 |     81,907       27.75      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen motorcycle = R1801H == 1

. tab R1801I

     R1801I |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      7,801        2.64        2.64
          5 |    287,354       97.36      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen boat = R1801I == 1

. tab R1801J

     R1801J |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      6,394        2.17        2.17
          5 |    288,761       97.83      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen motorboat = R1801J == 1

. tab R1801K

     R1801K |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     31,829       10.78       10.78
          5 |    263,326       89.22      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen car = R1801K == 1

. 
. *** House characteristics
. summ R1502

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
       R1502 |    295,155    1.306049     .718092          1          5

. gen ownhouse = R1502 == 1

. gen lease = R1502 == 2

. gen freelease = R1502 == 3

. gen companyhouse = R1502 == 4

. gen otherhouse = R1502 == 5

. 
. tab R1507

      R1507 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      4,721        1.60        1.60
          2 |    109,125       36.97       38.57
          3 |     21,533        7.30       45.87
          4 |    148,725       50.39       96.26
          5 |        361        0.12       96.38
          6 |      2,368        0.80       97.18
          7 |      8,018        2.72       99.90
          8 |        304        0.10      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen concreteroof = R1507 == 1

. gen tileroof = R1507 == 2

. gen asbestosroof = R1507 == 3

. gen ironsheetroof = R1507 == 4

. gen bambooroof = R1507 == 5

. gen shinglewoodroof = R1507 == 6

. gen fiberpalmroof = R1507 == 7

. gen otherroof = R1507 == 8

. 
. tab R1508

      R1508 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    191,598       64.91       64.91
          2 |      3,782        1.28       66.20
          3 |     81,225       27.52       93.72
          4 |      8,344        2.83       96.54
          5 |      1,339        0.45       97.00
          6 |      3,025        1.02       98.02
          7 |      5,842        1.98      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen concretewall = R1508 == 1

. gen wovenbamboowall = R1508 == 2

. gen woodwall = R1508 == 3

. gen wovenwoodwall = R1508 == 4

. gen logwoodwall = R1508 == 5

. gen bamboowall = R1508 == 6

. gen otherwall = R1508 == 7

. 
. tab R1509

      R1509 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      2,824        0.96        0.96
          2 |    115,243       39.04       40.00
          3 |        677        0.23       40.23
          4 |     14,239        4.82       45.06
          5 |     46,961       15.91       60.97
          6 |     97,632       33.08       94.04
          7 |      2,265        0.77       94.81
          8 |     14,872        5.04       99.85
          9 |        442        0.15      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen marblegranitefloor = R1509 == 1

. gen ceramicfloor = R1509 == 2

. gen parquettevinylfloor = R1509 == 3

. gen tilefloor = R1509 == 4

. gen woodfloor = R1509 == 5

. gen cementbrickfloor = R1509 == 6

. gen bamboofloor = R1509 == 7

. gen soilfloor = R1509 == 8

. gen otherfloor = R1509 == 9

. 
. *** Toilet variables
. tab R1510A

     R1510A |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    226,457       76.72       76.72
          2 |     23,337        7.91       84.63
          3 |      9,725        3.29       87.93
          4 |        410        0.14       88.07
          5 |     35,226       11.93      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen personaltoilet = R1510A == 1

. gen mutualtoilet = R1510A == 2

. gen communaltoilet = R1510A == 3

. gen notusetoilet = R1510A == 4

. gen noaccesstotoilet = R1510A == 5

. 
. tab R1510B

     R1510B |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    229,090       91.71       91.71
          2 |      2,762        1.11       92.82
          3 |      3,652        1.46       94.28
          4 |     14,290        5.72      100.00
------------+-----------------------------------
      Total |    249,794      100.00

. di (_N - 249794) / _N
.15368535

. // R1510B (toilet type) variable is missing 15% of values
. // this bc question not asked unless fam has personal or mutual toilet
. gen goosetoilet = R1510B == 1

. gen closedpitttoilet = R1510B == 2

. gen unclosedpitttoilet = R1510B == 3

. gen squattoilet = R1510B == 4

. gen notoilet = R1510B == .              // R1510B is missing if no toilet

. 
. // NOTE: full set of interactions does not seem to make sense here, bc notoilet = (personaltoilet == 0 & mutualtoilet == 
> 0)
. // need to think more carefully about this
. la var R1510A "Toilet Access"

. la var R1510B "Toilet Type"

. tab R1510A R1510B

    Toilet |                 Toilet Type
    Access |         1          2          3          4 |     Total
-----------+--------------------------------------------+----------
         1 |   209,488      2,451      3,193     11,325 |   226,457 
         2 |    19,602        311        459      2,965 |    23,337 
-----------+--------------------------------------------+----------
     Total |   229,090      2,762      3,652     14,290 |   249,794 

. gen personalgoosetoilet = personaltoilet * goosetoilet

. gen personalclosedpitttoilet = personaltoilet * closedpitttoilet

. gen personalunclosedpitttoilet = personaltoilet * unclosedpitttoilet

. gen personalsquattoilet = personaltoilet * squattoilet

. summ personalgoosetoilet personalclosedpitttoilet personalunclosedpitttoilet personalsquattoilet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
personalgo~t |    295,155    .7097559    .4538757          0          1
personalcl~t |    295,155    .0083041    .0907479          0          1
personalun~t |    295,155     .010818    .1034459          0          1
personalsq~t |    295,155    .0383697    .1920874          0          1

. 
. gen mutualgoosetoilet = mutualtoilet * goosetoilet

. gen mutualclosedpitttoilet = mutualtoilet * closedpitttoilet

. gen mutualunclosedpitttoilet = mutualtoilet * unclosedpitttoilet

. gen mutualsquattoilet = mutualtoilet * squattoilet

. summ mutualgoosetoilet mutualclosedpitttoilet mutualunclosedpitttoilet mutualsquattoilet

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
mutualgoos~t |    295,155    .0664126    .2490023          0          1
mutualclos~t |    295,155    .0010537    .0324434          0          1
mutualuncl~t |    295,155    .0015551    .0394043          0          1
mutualsqua~t |    295,155    .0100456    .0997231          0          1

. 
. tab R1510D

     R1510D |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    192,674       77.13       77.13
          2 |      1,975        0.79       77.92
          3 |     16,325        6.54       84.46
          4 |     36,772       14.72       99.18
          5 |      1,038        0.42       99.60
          6 |      1,010        0.40      100.00
------------+-----------------------------------
      Total |    249,794      100.00

. di _N
295155

. count if R1510A == 1 | R1510A == 2 &R1510D != .
  249,794

. // R1510D (final disposal site) is missing if no toilet
. gen septicdisposal = R1510D == 1

. gen pooldisposal = R1510D == 2

. gen riverdisposal = R1510D == 3

. gen pitholedisposal = R1510D == 4

. gen opendisposal = R1510D == 5

. gen otherdisposal = R1510D == 6

. 
. tab R1511A

     R1511A |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |     18,129        6.14        6.14
          2 |     73,374       24.86       31.00
          3 |     33,256       11.27       42.27
          4 |     39,351       13.33       55.60
          5 |     50,363       17.06       72.66
          6 |     17,636        5.98       78.64
          7 |     30,034       10.18       88.82
          8 |     12,005        4.07       92.88
          9 |      7,789        2.64       95.52
         10 |     12,994        4.40       99.92
         11 |        224        0.08      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen bottleddrinkwater = R1511A == 1

. gen refilldrinkwater = R1511A == 2

. gen tapdrinkwater = R1511A == 3

. gen pumpdrinkwater = R1511A == 4

. gen protwelldrinkwater = R1511A == 5

. gen unprotwelldrinkwater = R1511A == 6

. gen protspringwater = R1511A == 7

. gen unprotspringdrinkwater = R1511A == 8

. gen riverdrinkwater = R1511A == 9

. gen raindrinkwater = R1511A == 10

. gen otherdrinkwater = R1511A == 11

. 
. // summ bottleddrinkwater refilldrinkwater tapdrinkwater pumpdrinkwater protwelldrinkwater unprotwelldrinkwater protsprin
> gwater unprotspringdrinkwater riverdrinkwater raindrinkwater otherdrinkwater
. 
. tab R1516A

     R1516A |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        433        0.15        0.15
          2 |      1,526        0.52        0.66
          3 |     55,363       18.76       19.42
          4 |     74,427       25.22       44.64
          5 |     72,237       24.47       69.11
          6 |     24,895        8.43       77.55
          7 |     29,368        9.95       87.50
          8 |     11,382        3.86       91.35
          9 |     17,880        6.06       97.41
         10 |      7,197        2.44       99.85
         11 |        447        0.15      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen bottledcookwater = R1516A == 1

. gen refillcookwater = R1516A == 2

. gen tapcookwater = R1516A == 3

. gen pumpcookwater = R1516A == 4

. gen protectedwellcookwater = R1516A == 5

. gen unprotectedwellcookwater = R1516A == 6

. gen protectedspringcookwater = R1516A == 7

. gen unprotectedspringcookwater = R1516A == 8

. gen rivercookwater = R1516A == 9

. gen raincookwater = R1516A == 10

. gen othercookwater = R1516A == 11

. 
. tab R1518A

     R1518A |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    244,195       82.73       82.73
          2 |     25,600        8.67       91.41
          3 |     14,027        4.75       96.16
          4 |     11,333        3.84      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen PLNelectricity = (R1518A == 1 | R1518A == 2)

. gen nonPLNelectricity = R1518A == 3

. gen nonelectricity = R1518A == 4

. 
. tab R1519

      R1519 |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      3,180        1.08        1.08
          1 |      1,499        0.51        1.59
          2 |      2,324        0.79        2.37
          3 |     15,127        5.13        7.50
          4 |    181,959       61.65       69.15
          5 |      1,288        0.44       69.58
          6 |         34        0.01       69.59
          7 |     22,437        7.60       77.20
          8 |          1        0.00       77.20
          9 |        382        0.13       77.33
         10 |     66,825       22.64       99.97
         11 |         99        0.03      100.00
------------+-----------------------------------
      Total |    295,155      100.00

. gen electricity = R1519 == 1

. gen lpgas5kg = R1519 == 2

. gen lpgas12kg = R1519 == 3

. gen lpgas3kg = R1519 == 4

. gen gasorbiogas = (R1519 == 5 | R1519 == 6)

. gen kerosene = R1519 == 7

. gen briquettecoal = R1519 == 8

. gen charcoal = R1519 == 9

. gen firewood = R1519 == 10

. gen otherenergy = R1519 == 11

. gen notcookingathome = R1519 == 0

. 
. gen cleandrinkwater = R1511B
(145,766 missing values generated)

. replace cleandrinkwater = 0 if cleandrinkwater != .
(149,389 real changes made)

. replace cleandrinkwater = 1 if inlist(R1511A, 1, 2, 3, 9, 10, 11)
(145,766 real changes made)

. 
. // merge with individual dataset
. merge 1:m URUT using "$importable/kor18ind_revisi_diseminasi.dta"

    Result                      Number of obs
    -----------------------------------------
    Not matched                             0
    Matched                         1,131,825  (_merge==3)
    -----------------------------------------

. drop _m

. 
. *** Demographic variables
. di _N
1131825

. summ R407

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
        R407 |  1,131,825    30.38015    20.32324          0         97

. 
. gen male = R405 == 1

. bysort URUT: egen totalmale = total(male)

. drop male

. 
. gen female = R405 == 2

. bysort URUT: egen totalfemale = total(female)

. drop female

. 
. gen child = R407 == 3

. bysort URUT: egen totalchild = total(child)

. drop child

. 
. gen own_cell = R714 == 1

. bysort URUT: egen n_cell_hh = total(own_cell)

. 
. gen usecomputer = R715 == 1

. bysort URUT: egen n_computer_hh = total(usecomputer)

. 
. gen useinternet = R716 == 1

. bysort URUT: egen n_internet_hh = total(useinternet)

. 
. duplicates drop URUT, force

Duplicates in terms of URUT

(836,670 observations deleted)

. 
. rename EXP_CAP month_pcexp

. 
. gen urban = R105 == 1

. rename R101 PROVINSI

. rename KABU kabu

. drop R* NU* CATATAN WI*

. 
. foreach var of var* {
  2.         rename `var' mar18_`var'
  3. }

. 
. rename *PROVINSI PROVINSI

. rename *kabu kabu

. rename *urban urban

. rename *URUT URUT

. rename *FWT FWT

. 
. * address split districts
. gen id_mar18 = kabu

. rename kabu id_jan14

. replace id_jan14 = 7402 if id_jan14 == 7413 // Muna Barat, split from Muna
(130 real changes made)

. replace id_jan14 = 7401 if id_jan14 == 7414 // Buton Tengah, split from Buton
(180 real changes made)

. replace id_jan14 = 7401 if id_jan14 == 7415 // Buton Selatan, split from Buton
(130 real changes made)

. 
. ds
PROVINSI      mar18_boat    mar18_othe~f  mar18_soil~r  mar18_pers..  mar18_protw~  mar18_rive..  mar18_othe~y
mar18_nhhh~e  mar18_moto~t  mar18_conc~l  mar18_oth~or  mar18_mutu..  mar18_unpr..  m~ncookwater  mar18_notc~e
mar18_area    mar18_car     ~nbamboowall  m~onaltoilet  mar18_mutu..  mar18~gwater  mar18_othe..  mar18_clea~r
FWT           mar18_ownh~e  mar18_wood~l  ma~ualtoilet  mar18_mutu..  m~springdr~r  mar18_PLNe~y  mar18_~lmale
mar18_mont~p  mar18_lease   ma~nwoodwall  mar18_comm~t  mar18_mutu..  mar18_rive..  mar18_nonP~y  mar18_~emale
id_jan14      mar18_free~e  mar18_logw~l  mar18_notu~t  mar18_sept~l  mar18_raind~  mar18_none~y  mar18_tota~d
URUT          mar18_comp~e  mar18_bamb~l  mar18_noac~t  mar18_pool~l  mar18_othe..  mar18_elec~y  mar18_own_~l
mar18_lpg5~e  mar18_othe~e  mar18_oth~ll  mar18_goos~t  mar18_rive~l  m~dcookwater  mar18_lp~5kg  mar18_n_ce~h
mar18_regi~r  mar18_conc~f  mar18_marb~r  mar18_clos~t  mar18_pith~l  mar18_refi..  mar18_lp~2kg  mar18_usec~r
mar18_airc~r  mar18_tile~f  mar18_cera~r  mar18_uncl~t  mar18_open~l  mar18_tapc~r  mar18_lp~3kg  mar18_n_co~h
mar18_wate~r  mar18_asbe~f  mar18_parq~r  mar18_squa~t  mar18_oth~al  mar18_pumpc~  mar18_gaso~s  mar18_usei~t
mar18_land~e  mar18_iron~f  mar18_tile~r  mar18_noto~t  ~ddrinkwater  mar18_prot..  mar18_kero~e  mar18_n_in~h
mar18_comp~r  mar18_bamb~f  mar18_wood~r  mar18_pers..  mar18_refi..  mar18_unpr..  mar18_briq~l  urban
mar18_gold~m  mar18_shin~f  mar18_ceme~r  mar18_pers..  mar18_tapd~r  mar18_prot..  mar18_char~l  id_mar18
mar18_moto~e  mar18_fibe~f  mar18_bamb~r  mar18_pers..  mar18_pumpd~  mar18_unpr..  mar18_fire~d

. tempfile sus18

. save `sus18'
file /var/folders/23/7_md6wbn6ns7m_ppp9yb96sh0000gp/T//S_18300.000003 saved as .dta format

. 
. 
. /*----------------------------------------------------*/
.             /* Section: Merge and collapse */
. /*----------------------------------------------------*/
. 
. // Merge in jan 2014 ID from crosswalk and collapse
. *get the names from crosswalk file
. use "$importable/kabpanel19802014usingUndangUndang.dta", clear

. keep id_jan14 kab_jan14 id_dec04 kab_dec04

. duplicates drop

Duplicates in terms of all variables

(0 observations are duplicates)

. 
. // rename id_jan14 kabu_id
. forvalues year = 16 / 18 {
  2.         preserve
  3.         merge 1:m id_jan14 using `sus`year''
  4.         assert _m == 3 // all matched
  5.         drop _m
  6. 
.         // NOTE: need 2004 ids to match with the PPLS Lasso control pool
.         // drop kabu_id kab_jan14
.         // rename kab_dec04 kabu_name
.         // rename id_dec04 kabu_id
. 
.         // Collapse following procedure in BDT Dropbox
.         if `year' == 18 {
  7.                 collapse (mean) mar`year'* [aw=FWT], by(id_jan14 urban)
  8.         }
  9.         else {
 10.                 collapse (mean) mar`year'* [aw=fwt], by(id_jan14 urban)
 11.         }
 12. 
.         summ mar`year'*
 13. 
.         save "$cleaned/mar_20`year'_baseline_pool.dta", replace
 14.         restore
 15. }

    Result                      Number of obs
    -----------------------------------------
    Not matched                             0
    Matched                           291,414  (_merge==3)
    -----------------------------------------

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
mar16_n_hh~e |        957    1.188977    .1153977   .8978961   2.403667
  mar16_area |        957    73.05288    17.41294   11.34977   164.8017
mar16_mont~p |        957    987321.7      320729   339010.7    2664748
mar16_ownh~e |        957    .8291924    .1287488   .1688045          1
 mar16_lease |        957      .07097    .0898934          0   .5370031
-------------+---------------------------------------------------------
mar16_free~e |        957    .0787613      .05956          0   .5764343
mar16_comp~e |        957    .0186654    .0399163          0   .4619657
mar16_othe~e |        957    .0024109     .007349          0    .085906
mar16_conc~f |        957    .0143504    .0216654          0   .2447864
mar16_tile~f |        957    .0091638    .0213532          0   .1854904
-------------+---------------------------------------------------------
mar16_meta~f |        957    .0185257    .0309906          0   .2722046
mar16_clay~f |        957    .2685784    .3873632          0          1
mar16_asbe~f |        957    .0631345    .1219635          0   .9127908
mar16_iron~f |        957    .5759562    .3926821          0          1
mar16_bamb~f |        957    .0021889      .00671          0    .104625
-------------+---------------------------------------------------------
mar16_shin~f |        957    .0111493    .0362612          0   .3514246
mar16_fibe~f |        957    .0358454    .1025097          0   .9925878
mar16_othe~f |        957           0           0          0          0
mar16_conc~l |        957     .612834    .2704494          0          1
~nbamboowall |        957    .0141181    .0614647          0   .7147877
-------------+---------------------------------------------------------
mar16_wood~l |        957    .3034203    .2660806          0          1
ma~nwoodwall |        957    .0294223    .0624973          0   .4907627
mar16_logw~l |        957    .0058883    .0180626          0   .3237244
mar16_bamb~l |        957    .0129953    .0525379          0   .5989933
mar16_oth~ll |        957    .0213217    .0718813          0   .7083529
-------------+---------------------------------------------------------
mar16_marb~r |        957    .0084794    .0164426          0   .2715283
mar16_cera~r |        957    .3256415    .2057685          0   .8972994
mar16_parq~r |        957    .0010589    .0047055          0    .094023
mar16_tile~r |        957    .0465565    .0613771          0   .4497796
mar16_high~r |        957    .0593386    .0972472          0   .7843451
-------------+---------------------------------------------------------
mar16_ceme~r |        957    .3786786    .2210706          0   .9385726
mar16_bamb~r |        957    .0070374    .0398668          0   .6258535
mar16_lowq~r |        957    .1225147    .1738025          0   .9122694
mar16_soil~r |        957    .0481891     .094021          0   .8726024
mar16_oth~or |        957    .0025054    .0316033          0   .9344655
-------------+---------------------------------------------------------
m~onaltoilet |        957    .7496323    .1659008   .0398586          1
ma~ualtoilet |        957    .0875885    .0653938          0   .4123956
m~unaltoilet |        957    .0351633    .0552814          0   .5065023
mar16_notu~t |        957    .0027111    .0068514          0   .0894064
mar16_noac~t |        957    .1249048    .1376869          0   .9507859
-------------+---------------------------------------------------------
mar16_goos~t |        957     .776892    .1938578          0          1
mar16_clos~t |        957    .0144277    .0282542          0   .3568832
mar16_uncl~t |        957    .0168181    .0387692          0   .5096024
mar16_squa~t |        957    .0642462    .1046957          0   .9503944
mar~notoilet |        957    .1276159    .1395568          0   .9507859
-------------+---------------------------------------------------------
mar16_pers.. |        957    .6793611    .1944866          0   .9966788
mar16_pers.. |        957    .0123367    .0261123          0   .3341385
mar16_pers.. |        957    .0132765    .0322374          0   .3712549
mar16_pers.. |        957    .0446579    .0856256          0   .9503944
mar16_mutu.. |        957    .0734669    .0604011          0    .363549
-------------+---------------------------------------------------------
mar16_mutu.. |        957    .0014848    .0050701          0   .0814764
mar16_mutu.. |        957    .0022163    .0082099          0   .1238337
mar16_mutu.. |        957    .0104205    .0248241          0   .2460552
mar16_comm.. |        957     .024064    .0444387          0   .5065023
mar16_comm.. |        957    .0006061    .0033427          0   .0527408
-------------+---------------------------------------------------------
mar16_comm.. |        957    .0013253     .006906          0   .1248978
mar16_comm.. |        957    .0091679    .0278858          0   .3476108
mar16_lpg5~e |        957    .1123542    .1260777          0   .7251501
mar16_refr~r |        957    .5080431     .215769          0    .921482
mar16_airc~r |        957    .0613495    .0764139          0   .4253629
-------------+---------------------------------------------------------
mar16_wate~r |        957    .0191871    .0306764          0   .2499338
mar16_land~e |        957    .0195675    .0321166          0   .2697358
mar16_comp~r |        957    .1983831    .1274276          0   .5933787
mar16_gold~m |        957    .1899824    .1191548          0   .6856934
mar16_moto~e |        957    .7044284    .1985753          0          1
-------------+---------------------------------------------------------
  mar16_boat |        957    .0324922    .0738132          0   .6553882
mar16_moto~t |        957    .0233522    .0494868          0   .3943745
   mar16_car |        957    .0999941    .0744438          0    .500438
mar16_sept~l |        957    .6712511    .2304062          0          1
mar16_pool~l |        957    .0103687    .0341612          0   .4521415
-------------+---------------------------------------------------------
mar16_rive~l |        957    .1268164    .1419818          0   .8965913
mar16_pith~l |        957    .1341532    .1614706          0   .9992341
mar16_open~l |        957    .0472509    .0840883          0   .6254773
mar16_oth~al |        957    .0101598    .0201827          0    .253554
~ddrinkwater |        957    .0406876    .0768912          0   .6080623
-------------+---------------------------------------------------------
mar16_refi.. |        957    .2459754    .2145981          0   .9824086
mar16_mete.. |        957    .1205765    .1636778          0   .9077901
mar16_reta.. |        957    .0133035    .0382868          0   .6757471
mar16_pumpd~ |        957    .1088307    .1311283          0   .7435811
mar16_protw~ |        957    .1977921    .1778745          0   .8568369
-------------+---------------------------------------------------------
mar16_unpr.. |        957    .0715541    .1079757          0   .7574517
mar16_prots~ |        957    .0910508    .1404349          0   .9717197
mar16_unpr.. |        957    .0374104     .096027          0          1
mar16_rive.. |        957    .0287552     .076502          0   .8915476
mar16_raind~ |        957    .0434095    .1292032          0   .9833654
-------------+---------------------------------------------------------
mar16_othe.. |        957    .0006539    .0034036          0   .0606124
mar16_pers~r |        957    .4353181     .199145          0          1
mar16_mutu~r |        957    .1235047    .0947704          0   .5979618
mar16_comm~r |        957    .0942263    .1314724          0   .9975982
mar16_notu~r |        957    .0000894    .0009288          0   .0189884
-------------+---------------------------------------------------------
mar16_noac~r |        957     .046895    .1036044          0   .8683734
mar16_buyi~r |        957    .2710501    .2144328          0          1
mar16_subs~r |        957    .1934056    .1834707          0   .9501482
mar16_notb~r |        957    .5355443    .2798795          0          1
m~dcookwater |        957    .0047888    .0125191          0    .142596
-------------+---------------------------------------------------------
mar16_refi.. |        957    .0555616    .0893949          0   .7938599
mar16_mete.. |        957    .1821391    .2194359          0   .9132269
mar16_reta.. |        957    .0181056    .0434445          0   .7099004
mar16_pumpc~ |        957    .1639023      .18703          0   .9958732
mar16_prot.. |        957    .2459008    .2013375          0   .9417272
-------------+---------------------------------------------------------
mar16_unpr.. |        957    .0900243    .1246503          0   .8793415
mar16_prot.. |        957    .0981604    .1451665          0   .9935763
mar16_unpr.. |        957    .0435998    .1009433          0   .9956875
mar16_rive.. |        957    .0352928    .0884153          0   .8915476
mar16_rainc~ |        957    .0555358    .1543027          0   .9979115
-------------+---------------------------------------------------------
mar16_othe.. |        957    .0017477    .0056309          0   .0606124
mar16_coo~13 |        957     .005241    .0137072          0   .1786362
m~dwashwater |        957    .0005837    .0026816          0   .0438897
mar16_refi.. |        957    .0011243    .0031856          0   .0318734
mar16_mete.. |        957    .1857278    .2209513          0   .9213069
-------------+---------------------------------------------------------
mar16_reta.. |        957    .0111309    .0248604          0   .3949609
mar16_pumpw~ |        957    .1939153    .2100724          0          1
mar16_prot.. |        957    .2658642    .2020637          0   .9948035
mar16_unpr.. |        957    .1072065    .1295174          0   .8793415
mar16_prot.. |        957    .0907541    .1388251          0   .9738201
-------------+---------------------------------------------------------
mar16_unpr.. |        957    .0385329    .0777713          0   .7952998
mar16_rive.. |        957    .0838906    .1452502          0   .9860364
mar16_rainw~ |        957    .0195391    .0608194          0     .58338
mar16_othe.. |        957    .0017307    .0069278          0   .1112072
mar1~pewater |        957    .4516754    .2630631          0          1
-------------+---------------------------------------------------------
mar16~twater |        957    .0230782    .0453364          0   .5669056
mar16_clea.. |        957    .4933618    .2787843          0          1
~ancookwater |        957    .3556701    .2771417          0          1
~anwashwater |        957    .3037271    .2529524          0          1
mar16_exp_~p |        957    987321.7      320729   339010.7    2664748
-------------+---------------------------------------------------------
mar16_~lmale |        957    2.019222     .239478   1.365712    4.18303
mar16_~emale |        957    1.978476    .2271231   1.426303   3.242037
mar16_tota~d |        957    1.707712     .356252   .8751472   5.081308
mar16_n_ce~h |        957    2.029328    .5042445          0   3.238231
mar16_own_~l |        957    .8815044    .1321021          0          1
-------------+---------------------------------------------------------
mar16_n_co~h |        957    .5925924    .3767613          0   2.150209
mar16_usec~r |        957    .3233741    .1630734          0   .7896405
mar16_usei~d |        957    .2020624    .1189937          0   .6254549
mar16_n_in~h |        957    .8065671    .4390836          0    2.13062
mar16_usei~t |        957    .4373892    .1870179          0   .9043029
-------------+---------------------------------------------------------
mar16_n_ho~h |        957     .723296    .4122549          0   2.047949
mar16_home~t |        957    .3923552    .1784695          0    .818952
mar16_n_no~h |        957    .2861284    .2166912          0    1.58588
mar16_no~net |        957    .1777492    .1127728          0   .7458776
mar16_n_of~h |        957     .256425    .1938756          0   1.147593
-------------+---------------------------------------------------------
mar16_offi~t |        957    .1829646    .1269292          0   .6632938
mar16_n_sc~h |        957    .1831806    .1270835          0   1.059789
mar16_scho~t |        957    .1424438    .0880603          0   .4877191
mar16_n_pu~h |        957    .3557748    .2454788          0   1.919829
mar16_publ~t |        957    .2216931     .128964          0   .9043029
-------------+---------------------------------------------------------
mar16_n_ve~h |        957    .0677837    .0954342          0   .7406237
mar16_vehi~t |        957    .0424392    .0522558          0   .4154633
mar16_int_~n |        957    .3532722    .1732397          0   .8625844
mar16_int_~k |        957     .194705    .1078172          0   .5991923
mar16_int~il |        957    .1389831    .1036636          0    .649422
-------------+---------------------------------------------------------
mar16_int_~a |        957     .384257    .1794773          0   .8556601
mar16_int_~e |        957    .0676246    .0646366          0     .41124
mar16_in~nal |        957    .2315431    .1462497          0   .6924085
mar16_in~ial |        957    .0413699     .047112          0   .3231988
mar16_int_~r |        957    .0197119    .0254528          0   .2255782
-------------+---------------------------------------------------------
mar16_PLNe~y |        957    .8979865    .2000355          0          1
mar16_nonP~y |        957    .0488848    .1034984          0          1
mar16_none~y |        957    .0531287    .1405364          0          1
mar16_elec~y |        957    .0057376    .0103688          0   .0996572
mar16_lp~5kg |        957    .0026993    .0075008          0   .0880273
-------------+---------------------------------------------------------
mar16_lp~2kg |        957    .0587032    .0848615          0   .6193623
mar16_lp~3kg |        957    .5334649    .3246476          0    .995308
mar16_gaso~s |        957    .0014359    .0129456          0   .2076159
mar16_kero~e |        957    .1275856    .2357635          0          1
mar16_briq~l |        957    .0000396    .0004877          0   .0094441
-------------+---------------------------------------------------------
mar16_char~l |        957    .0023626    .0151772          0   .2527592
mar16_fire~d |        957    .2611089    .2564696          0          1
mar16_othe~y |        957    .0015765    .0043347          0    .042654
mar16_notc~e |        957     .005286    .0137187          0   .1786362
file /Users/clotairemit.edu/Dropbox (MIT)/J-PAL Raskin Transition/10_Analysis&Results/Agent Experiment
    Analysis/01_Data/cleaned/mar_2016_baseline_pool.dta saved

    Result                      Number of obs
    -----------------------------------------
    Not matched                             0
    Matched                           297,276  (_merge==3)
    -----------------------------------------

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
mar17_n_hh~e |        957    1.051019     .104621          1   2.602834
  mar17_area |        957    76.72194    17.29393   14.71321   152.3199
mar17_mont~p |        957     1091860    376832.4   382658.9    4981529
 mar17_renum |        957    156089.6    91845.34   39.71587   297253.9
mar17_ownh~e |        957     .803867     .133823   .1763924          1
-------------+---------------------------------------------------------
 mar17_lease |        957    .0784886    .0939255          0   .5705672
mar17_free~e |        957    .0954558    .0654891          0   .8114522
mar17_c~ouse |        957    .0200933    .0486042          0   .6943405
mar17_othe~e |        957    .0020952    .0068617          0   .1163493
mar17_conc~f |        957    .0122513    .0197436          0   .1583403
-------------+---------------------------------------------------------
mar17_tile~f |        957    .2879057    .3936517          0          1
mar17_asbe~f |        957     .064223    .1214039          0    .856021
mar17_iron~f |        957    .5949148    .3976318          0          1
mar17_bamb~f |        957    .0012049    .0042503          0   .0478619
mar17_shin~f |        957    .0088428     .031021          0   .2909332
-------------+---------------------------------------------------------
mar17_fibe~f |        957    .0291724    .0866071          0   .8851609
mar17_othe~f |        957     .001485    .0246088          0   .7467063
mar17_conc~l |        957     .623796    .2667499          0          1
~nbamboowall |        957    .0153371     .061874          0   .6534963
mar17_wood~l |        957    .3012634    .2622339          0   .9992698
-------------+---------------------------------------------------------
ma~nwoodwall |        957    .0253584    .0552709          0   .6196385
mar17_logw~l |        957    .0037811     .013193          0   .2447312
mar17_bamb~l |        957    .0112044    .0484359          0   .6108991
mar17_oth~ll |        957    .0192595    .0715971          0   .7347044
mar17_marb~r |        957    .0098046    .0170703          0     .23394
-------------+---------------------------------------------------------
mar17_cera~r |        957    .3453582    .2133946          0   .9270017
mar17_parq~r |        957    .0018685    .0060026          0   .0991312
mar17_tile~r |        957    .0460624    .0615277          0   .4241453
mar17_high~r |        957    .1759822    .2392365          0          1
mar17_ceme~r |        957    .3691301    .2201499          0          1
-------------+---------------------------------------------------------
mar17_bamb~r |        957    .0065388    .0358144          0   .5794494
mar17_soil~r |        957    .0434813    .0882934          0   .8407177
mar17_oth~or |        957    .0017739    .0205232          0   .5781638
m~onaltoilet |        957    .7647892    .1555826   .0092865          1
ma~ualtoilet |        957    .0838231    .0682081          0   .5016435
-------------+---------------------------------------------------------
mar17_comm~t |        957    .0335901    .0548109          0   .5751072
mar17_notu~t |        957    .0012984    .0039197          0   .0594573
mar17_noac~t |        957    .1164993    .1277772          0   .9611326
mar17_goos~t |        957    .7749384    .1884689          0          1
mar17_clos~t |        957    .0097566    .0200936          0   .3799354
-------------+---------------------------------------------------------
mar17_uncl~t |        957    .0143355    .0379686          0   .5420272
mar17_squa~t |        957    .0495817    .0849523          0   .8143545
mar~notoilet |        957    .1513878    .1455158          0   .9686282
mar17_pers.. |        957    .7052018    .1843414          0          1
mar17_pers.. |        957    .0085839    .0185766          0   .3725656
-------------+---------------------------------------------------------
mar17_pers.. |        957    .0127111    .0356395          0   .5420272
mar17_pers.. |        957    .0382924    .0694074          0   .7082705
mar17_mutu.. |        957    .0697367    .0609109          0   .4260779
mar17_mutu.. |        957    .0011727    .0043609          0   .0751652
mar17_mutu.. |        957    .0016244    .0062795          0   .0845604
-------------+---------------------------------------------------------
mar17_mutu.. |        957    .0112893    .0331468          0   .4920874
mar17_lpg5~e |        957    .0998036    .1107397          0    .703683
mar17_refr~r |        957    .5238086    .2128061          0          1
mar17_airc~r |        957    .0648634    .0816058          0   .4172608
mar17_wate~r |        957    .0168814    .0297409          0   .2811643
-------------+---------------------------------------------------------
mar17_land~e |        957    .0186714    .0284879          0   .1582951
mar17_comp~r |        957    .1966729    .1230715          0   .6065423
mar17_gold~m |        957    .1994518     .118941          0   .7971573
mar17_moto~e |        957    .7203799    .1842005          0          1
  mar17_boat |        957    .0327211    .0668145          0   .7944827
-------------+---------------------------------------------------------
mar17_moto~t |        957    .0263541    .0497152          0   .4036603
   mar17_car |        957    .1048503    .0745763          0   .4913507
mar17_sept~l |        957    .6504526    .2370949          0          1
mar17_pool~l |        957    .0063018    .0290706          0   .6240166
mar17_rive~l |        957    .0540858    .0894847          0   .8245952
-------------+---------------------------------------------------------
mar17_pith~l |        957    .1288971    .1579312          0   .8911678
mar17_open~l |        957    .0056571    .0270701          0   .4578757
mar17_oth~al |        957    .0032179    .0163723          0   .3032331
~ddrinkwater |        957    .0469293    .0899028          0   .8662365
mar17_refi.. |        957    .2796735    .2263957          0   .9943493
-------------+---------------------------------------------------------
mar17_tapd~r |        957    .1302341     .166927          0   .9664381
mar17_pumpd~ |        957    .1136864    .1325953          0   .7933087
mar17_protw~ |        957    .1752439    .1633463          0   .7872426
mar17_unpr.. |        957    .0614701    .0998569          0   .8218153
mar17_prots~ |        957    .0894691    .1421997          0   .9381598
-------------+---------------------------------------------------------
mar17_unpr.. |        957    .0347059    .0844455          0          1
mar17_rive.. |        957    .0234739    .0636714          0   .6929201
mar17_raind~ |        957    .0448196    .1325993          0   .9848064
mar17_othe.. |        957    .0002943    .0014952          0   .0177222
m~dcookwater |        957    .0014767    .0053784          0   .0606394
-------------+---------------------------------------------------------
mar17_refi.. |        957    .0050778    .0133169          0   .1501417
mar17_tapc~r |        957    .2092102    .2358358          0    .978528
mar17_pumpc~ |        957    .2175308    .2158062          0          1
mar17_prot.. |        957    .2613229    .1997364          0   .9613312
mar17_unpr.. |        957    .0914952    .1224203          0    .909122
-------------+---------------------------------------------------------
mar17_prot.. |        957      .08996    .1425259          0   .9809342
mar17_unpr.. |        957    .0358008    .0831492          0   .9990095
mar17_rive.. |        957    .0595734    .1151478          0   .9222499
mar17_rainc~ |        957    .0275281    .0804017          0   .8379734
mar17_othe.. |        957    .0010242    .0046541          0   .0841779
-------------+---------------------------------------------------------
mar17_clea.. |        957    .5254247     .276538          0          1
~ancookwater |        957    .3038904    .2531906          0          1
mar17_PLNe~y |        957    .9120157    .1899274          0          1
mar17_nonP~y |        957    .0458998    .1056428          0          1
mar17_none~y |        957    .0420845    .1259912          0          1
-------------+---------------------------------------------------------
mar17_elec~y |        957    .0044225    .0111843          0   .1040137
mar17_lp~5kg |        957    .0039659    .0084908          0   .1161844
mar17_lp~2kg |        957    .0539044    .0767928          0   .5110146
mar17_lp~3kg |        957    .5799143    .3284774          0          1
mar17_gaso~s |        957    .0019137    .0160875          0   .2637343
-------------+---------------------------------------------------------
mar17_kero~e |        957      .12456    .2373355          0          1
mar17_briq~l |        957    4.86e-06    .0001229          0   .0036774
mar17_char~l |        957     .001554    .0106225          0   .2147081
mar17_fire~d |        957    .2186743    .2434367          0          1
mar17_othe~y |        957    .0002891     .001831          0   .0265881
-------------+---------------------------------------------------------
mar17_notc~e |        957     .010797    .0198361          0   .1868863
mar17_~lmale |        957    2.014958    .2306624    1.42595   3.026936
mar17_~emale |        957    1.976157    .2278192   1.487308   2.946657
mar17_tota~d |        957    1.665502    .3267434   .8506893   2.960904
  mar17_cell |        957    .5416349    .1316611          0   .9322763
-------------+---------------------------------------------------------
mar17_n_ce~h |        957    2.076916    .4870782          0   3.669334
mar17_own_~l |        957    .8908924    .1147718          0          1
mar17_c~ruse |        957    .1655583    .0998482          0   .5662004
mar17_n_co~h |        957    .6639834    .3780835          0   2.488364
mar17_usec~r |        957    .3579837    .1578527          0   .8960274
-------------+---------------------------------------------------------
mar17_n_in~h |        957    1.024594    .4711365          0   2.409648
mar17_usei~t |        957    .5342421    .1860341          0   .9475081
mar17_n_ho~h |        957    .9171533    .4534367          0   2.409648
mar17_home~t |        957    .4788224    .1872835          0   .9475081
mar17_n_no~h |        957    .2822864    .2158744          0   1.561305
-------------+---------------------------------------------------------
mar17_no~net |        957    .1688555    .1120113          0   .6953156
mar17_n_of~h |        957    .2781701    .1993161          0   1.184133
mar17_offi~t |        957    .1970976     .130857          0   .7149383
mar17_n_sc~h |        957    .1738244    .1179304          0   .8361098
mar17_scho~t |        957    .1373972    .0839176          0   .4916856
-------------+---------------------------------------------------------
mar17_n_pu~h |        957    .1880845    .1738766          0   1.278417
mar17_publ~t |        957    .1171828    .0957648          0   .6346799
mar17_n_ve~h |        957     .139576    .1551311          0    1.69744
mar17_vehi~t |        957    .0816105    .0814563          0   .7692934
mar17_int_~n |        957    .3764354      .17226          0   .8481296
-------------+---------------------------------------------------------
mar17_int_~k |        957    .2081339    .1055745          0   .6541936
mar17_~l_ind |        957    .0569205    .0524702          0    .347967
mar17_int~il |        957    .1328983    .0948584          0   .6431974
mar17_~a_ind |        957    .2005428    .1124644          0   .6269929
mar17_int_~a |        957     .432919    .1736884          0   .9201232
-------------+---------------------------------------------------------
mar17_int_~e |        957    .0711818    .0652159          0   .3835501
mar17_in~nal |        957    .2690917    .1506564          0   .8099122
mar17_in~ial |        957    .0283455    .0403803          0   .3589136
mar17_int_~r |        957    .0108394    .0168449          0     .17065
file /Users/clotairemit.edu/Dropbox (MIT)/J-PAL Raskin Transition/10_Analysis&Results/Agent Experiment
    Analysis/01_Data/cleaned/mar_2017_baseline_pool.dta saved

    Result                      Number of obs
    -----------------------------------------
    Not matched                             0
    Matched                           295,155  (_merge==3)
    -----------------------------------------

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
mar18_nhhh~e |        958    1.077485    .1129526          1    2.38329
  mar18_area |        958    76.93123    17.66935   14.48698   153.6216
mar18_mont~p |        958     1169424    359454.6     377358    2907642
mar18_lpg5~e |        958    .1086765    .1128933          0   .6282767
mar18_regi~r |        958    .5428613    .2084435          0   .9845664
-------------+---------------------------------------------------------
mar18_airc~r |        958    .0680782    .0836689          0   .4023954
mar18_wate~r |        958    .0183256    .0306488          0   .4249451
mar18_land~e |        958     .013015    .0235706          0   .2394539
mar18_comp~r |        958    .2040759    .1221172          0   .6481535
mar18_gold~m |        958    .1827729    .1077314          0   .6439524
-------------+---------------------------------------------------------
mar18_moto~e |        958    .7337497     .178222          0   .9959857
  mar18_boat |        958     .032844    .0632043          0   .6647831
mar18_moto~t |        958    .0277288     .052976          0   .4588999
   mar18_car |        958    .1103099    .0740864          0   .4408567
mar18_ownh~e |        958    .8097242    .1282423   .2345165          1
-------------+---------------------------------------------------------
 mar18_lease |        958    .0771124    .0903208          0   .5359319
mar18_free~e |        958    .0930711    .0639382          0   .7113419
mar18_comp~e |        958    .0174787     .037898          0   .4482946
mar18_othe~e |        958    .0026136    .0069479          0   .0872176
mar18_conc~f |        958    .0156425    .0240022          0   .2760867
-------------+---------------------------------------------------------
mar18_tile~f |        958    .2834876    .3886363          0          1
mar18_asbe~f |        958    .0644944    .1211161          0          1
mar18_iron~f |        958    .5997269    .3974263          0          1
mar18_bamb~f |        958    .0012509    .0037795          0   .0428561
mar18_shin~f |        958    .0085665    .0303841          0     .27481
-------------+---------------------------------------------------------
mar18_fibe~f |        958    .0257946    .0835045          0   .9926826
mar18_othe~f |        958    .0010365     .005266          0   .1107931
mar18_conc~l |        958    .6345864     .264077          0          1
~nbamboowall |        958    .0132159     .055546          0   .6911938
mar18_wood~l |        958    .2933992    .2564463          0   .9950418
-------------+---------------------------------------------------------
ma~nwoodwall |        958    .0237498    .0532455          0   .4455491
mar18_logw~l |        958    .0043665    .0145765          0   .2180069
mar18_bamb~l |        958    .0094364    .0470714          0   .6361595
mar18_oth~ll |        958    .0212458    .0736111          0   .7298778
mar18_marb~r |        958    .0097927    .0154988          0   .1454664
-------------+---------------------------------------------------------
mar18_cera~r |        958    .3638375    .2148555          0   .9295783
mar18_parq~r |        958    .0024647    .0101246          0   .1768252
mar18_tile~r |        958    .0432027    .0603986          0   .5412133
mar18_wood~r |        958    .1704061    .2342217          0   .9847149
mar18_ceme~r |        958      .36192     .214997          0          1
-------------+---------------------------------------------------------
mar18_bamb~r |        958    .0064182    .0379323          0   .6224012
mar18_soil~r |        958    .0406775     .087544          0   .8351502
mar18_oth~or |        958    .0012806    .0089064          0   .1455912
m~onaltoilet |        958    .7817241    .1496455   .0358026          1
ma~ualtoilet |        958    .0762235    .0620397          0   .4461395
-------------+---------------------------------------------------------
mar18_comm~t |        958     .033065    .0513044          0    .381355
mar18_notu~t |        958     .001398    .0044696          0   .0495229
mar18_noac~t |        958    .1075896    .1244298          0   .9641975
mar18_goos~t |        958    .7937083    .1803298   .0039294          1
mar18_clos~t |        958    .0084756    .0167327          0   .2127526
-------------+---------------------------------------------------------
mar18_uncl~t |        958     .011708    .0282789          0   .3036895
mar18_squa~t |        958    .0440556    .0830743          0   .8202531
mar18_noto~t |        958    .1420525    .1420867          0   .9641975
mar18_pers.. |        958     .727951    .1784563   .0039294          1
mar18_pers.. |        958    .0076704    .0159486          0   .2065319
-------------+---------------------------------------------------------
mar18_pers.. |        958    .0104512    .0262117          0   .2883801
mar18_pers.. |        958    .0356515    .0713097          0   .6134929
mar18_mutu.. |        958    .0657574    .0572728          0   .4461395
mar18_mutu.. |        958    .0008052    .0025307          0   .0279263
mar18_mutu.. |        958    .0012568    .0040096          0   .0395687
-------------+---------------------------------------------------------
mar18_mutu.. |        958    .0084041    .0240495          0   .2741563
mar18_sept~l |        958    .6733889    .2326176          0          1
mar18_pool~l |        958    .0056647    .0210564          0    .320701
mar18_rive~l |        958    .0542541    .0862536          0   .8147124
mar18_pith~l |        958    .1169644    .1607971          0   .9535916
-------------+---------------------------------------------------------
mar18_open~l |        958    .0041805    .0165507          0   .1922408
mar18_oth~al |        958    .0034949    .0158818          0   .2944838
~ddrinkwater |        958    .0446502    .0840526          0   .7305721
mar18_refi.. |        958    .2926721    .2315285          0    .951157
mar18_tapd~r |        958     .127916    .1648733          0   .9559203
-------------+---------------------------------------------------------
mar18_pumpd~ |        958    .1195809    .1326549          0   .7010757
mar18_protw~ |        958     .163749    .1533101          0   .7948378
mar18_unpr.. |        958    .0564114    .0903453          0   .7951301
mar18~gwater |        958     .090176    .1411674          0   .9553934
m~springdr~r |        958    .0361849    .0930262          0          1
-------------+---------------------------------------------------------
mar18_rive.. |        958    .0227882     .058491          0   .5850812
mar18_raind~ |        958    .0451032    .1305225          0   .9565102
mar18_othe.. |        958    .0007683    .0042472          0   .0873884
m~dcookwater |        958    .0010097    .0037388          0   .0441599
mar18_refi.. |        958    .0048019    .0123499          0   .2172561
-------------+---------------------------------------------------------
mar18_tapc~r |        958    .2110535    .2355717          0          1
mar18_pumpc~ |        958    .2355153    .2200125          0   .9720676
mar18_prot.. |        958    .2499825    .1901482          0    .913774
mar18_unpr.. |        958    .0868802    .1146092          0   .8509748
mar18_prot.. |        958    .0907426    .1442294          0          1
-------------+---------------------------------------------------------
mar18_unpr.. |        958    .0358708    .0915689          0          1
mar18_rive.. |        958     .057173    .1034637          0   .7487028
m~ncookwater |        958    .0253543    .0749213          0   .8371333
mar18_othe.. |        958    .0016162    .0066726          0    .088108
mar18_PLNe~y |        958    .9222147    .1781524          0          1
-------------+---------------------------------------------------------
mar18_nonP~y |        958     .044682     .110246          0          1
mar18_none~y |        958    .0331032    .1028993          0          1
mar18_elec~y |        958    .0046541    .0102342          0   .0997027
mar18_lp~5kg |        958    .0075382    .0139337          0   .1194933
mar18_lp~2kg |        958    .0524583    .0747237          0   .5021389
-------------+---------------------------------------------------------
mar18_lp~3kg |        958    .5950671    .3335013          0          1
mar18_gaso~s |        958    .0033423    .0364349          0   .7619023
mar18_kero~e |        958    .1186395    .2323857          0   .9617686
mar18_briq~l |        958    1.39e-06     .000043          0   .0013311
mar18_char~l |        958    .0010132    .0074283          0   .1253626
-------------+---------------------------------------------------------
mar18_fire~d |        958    .2076076    .2369905          0          1
mar18_othe~y |        958    .0002398    .0014202          0   .0285052
mar18_notc~e |        958    .0094385    .0164367          0   .1671391
mar18_clea~r |        958    .5338979    .2724161          0          1
mar18_~lmale |        958     2.01534     .247457    1.41241   3.169572
-------------+---------------------------------------------------------
mar18_~emale |        958     1.97511    .2374822   1.418448   3.048946
mar18_tota~d |        958    .0775925    .0337438          0   .2861905
mar18_own_~l |        958     .565158    .1262685   .0304184   .8993522
mar18_n_ce~h |        958    2.175269    .4801661   .0889919   4.309374
mar18_usec~r |        958    .1641416    .0916728          0   .5289669
-------------+---------------------------------------------------------
mar18_n_co~h |        958    .6603907    .3506309          0   2.425377
mar18_usei~t |        958    .3158657    .1342417          0   .7345183
mar18_n_in~h |        958     1.25959    .4920115          0   2.610245
file /Users/clotairemit.edu/Dropbox (MIT)/J-PAL Raskin Transition/10_Analysis&Results/Agent Experiment
    Analysis/01_Data/cleaned/mar_2018_baseline_pool.dta saved

. 
. 
. cap log close
